# Calculations in calc with "empty"cells. [closed]

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?

edit retag reopen merge delete

### Closed for the following reason the question is answered, right answer was accepted by Alex Kemp close date 2015-10-28 02:31:04.126153

Sort by » oldest newest most voted

Try to use function N():

N(cell A)+N(cell B)-N(cell C)

more