# Multiplying with zeros formula help!

#### lukeyry

##### New Member
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.

### 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
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
Thank you works perfect! Just an addition to that, if B19 was a % value how do I add that to initial (B18/B16*60).

Replies
4
Views
48
Replies
1
Views
39
Replies
0
Views
46
Replies
2
Views
50
Replies
7
Views
55