Multiplying with zeros formula help!

lukeyry

New Member
Joined
May 1, 2013
Messages
2
Pretty new to excel so bear with me. Have to complete a table that responds to different values. I have a basic formula that is: =B18/B16*60 and i want it to be able to change in response to another cell and look like =(B18/B16*60)*B19. However I want B19 to be left as zero without making the whole equation equal 0. Hope that makes sense, any help appreciated.
 

Some videos you may like

Excel Facts

Select a hidden cell
Somehide hide payroll data in column G? Press F5. Type G1. Enter. Look in formula bar while you arrow down through G.

Firefly2012

Well-known Member
Joined
Dec 28, 2011
Messages
3,638
Hi

Possibly something like this:

=(B18/B16*60)*IF(B19="",1,B19)

So the B18/B16*60 would be unmodified if B19 is empty, if not then it would be multiplied by the value in B19 (if B19 is actually zero then change the test to IF(B19=0,1,B19)
 

lukeyry

New Member
Joined
May 1, 2013
Messages
2
Thank you works perfect! Just an addition to that, if B19 was a % value how do I add that to initial (B18/B16*60).
 

Watch MrExcel Video

Forum statistics

Threads
1,108,751
Messages
5,524,616
Members
409,595
Latest member
therevford

This Week's Hot Topics

Top