Multiplying with zeros formula help!

[lukeyry]

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.

 

[Firefly2012]

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]

Thank you works perfect! Just an addition to that, if B19 was a % value how do I add that to initial (B18/B16*60).