Multiply empty cells?

[Viggo]

I am multiplying a range of cells (containing IF
formulas). Can I get the multiplying to work even if the
target cells are empty?

 

[Paul]

I am multiplying a range of cells (containing IF
formulas). Can I get the multiplying to work even if the
target cells are empty?

What do you mean by "work"? In other words (if I follow your question
correctly), what do you expect to happen if, for example, you multiply 3 by
blank? Be more specific about your requirements - maybe an example of what
you want one formula to do - and you may get some help.

 

[vili]

I am multiplying 4 cells (G6:G9) containing IF formulas. Only two of
them will contain a value depending on the result of the formula. E.g.
it could be G6 and G8, or G6 and G9. I would prefer to multiply all 4
cells so I dont have to change the formula everytime the sheet is used.

 

[Paul]

I am multiplying 4 cells (G6:G9) containing IF formulas. Only two of
them will contain a value depending on the result of the formula. E.g.
it could be G6 and G8, or G6 and G9. I would prefer to multiply all 4
cells so I dont have to change the formula everytime the sheet is used.

What do the other two IF formulas return?
=PRODUCT(G6:G9) will ignore "" .

Alternatively, you could change the IF formulas so that the other two return
1 (rather than 0 or ""). That way,
=G6*G7*G8*G9
will work.