Multiply empty cells?

  • Thread starter Thread starter Viggo
  • Start date Start date
V

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?
 
Viggo said:
I am multiplying a range of cells (containing IF
formulas). Can I get the multiplying to work even if the
target cells are empty?
Click to expand...

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.
 
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.
 
vili said:
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.
Click to expand...

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.
 
Back
Top