Need empty cells not to be seen as zero

[linan]

hello,

Id appreciate your help on the below.

Im creating a template for a quotation to use everytime we need it.

However the formula is supposed to multiply four cells by each other corresponding to units, rate and days and episodes.
My problem is that not all cells are filled in each row, sometimes its only unit by rate, and others unit by day.. which means one of the four cells is empty which excel is calculating as zero therefore giving me a zero answer given that it is always multiplied by zero.

I figured out an IF formula being =IF(D16>0,B16*C16*E16*D16,B16*C16*E16) but this only works if D16 is empty but not the others.. how can i have the same formula apply to either of the other cells being empty?

Thank you,

Lina

 

[kidwispa]

hello,

Id appreciate your help on the below.

Im creating a template for a quotation to use everytime we need it.

However the formula is supposed to multiply four cells by each other corresponding to units, rate and days and episodes.
My problem is that not all cells are filled in each row, sometimes its only unit by rate, and others unit by day.. which means one of the four cells is empty which excel is calculating as zero therefore giving me a zero answer given that it is always multiplied by zero.

I figured out an IF formula being =IF(D16>0,B16*C16*E16*D16,B16*C16*E16) but this only works if D16 is empty but not the others.. how can i have the same formula apply to either of the other cells being empty?

Thank you,

Lina

Can more than one of the cells be empty or is it just likely to be one?

 

[kidwispa]

If only one will be empty at a time try this

=IF(B16=0,C16*D16*E16,IF(C16=0,B16*D16*E16,IF(D16=0,B16*C16*E16,IF(E16=0,B16*C16*D16,B16*C16*D16*E16))))

 

[linan]

Can more than one of the cells be empty or is it just likely to be one?

Yes there might be more than one cell empty sometime..

 

[Steeviee]

Try using the formula

=PRODUCT(B16:E16)

 

[kidwispa]

Try using the formula

=PRODUCT(B16:E16)

Beat me to it!

 

[linan]

Beat me to it!

It worked!! thanks so much i cant believe its so simple and i sat here working my brain all day...

Thank you very much both of you