Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Calculations in calc with "empty"cells.

I'm using an IF formula, to summ a range of numbers by a given variables, the formula shortened would be "=IF(SUMIF()=0;"";SUMIF())" it's supposed to check if the summ is grater than or equal to 0, if the summ is equal to 0, then the cell should be empty, if the summ is greater than 0 then it should summ the numbers. And after that, there is a formula (cell A + cell B - cell C) containing cells with this IF formula, but there is a problem with the "empty" cells, A+B-C formula result is #VALUE!

For now, the only solution I found would be changing the "THEN" variable of the IF formula to 0, but it would result in zeros instead of empty cells :( Is there a way to have "empty" cells and still have the A+B-C formula to work?