Ask Your Question

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

asked 2013-04-02 15:11:53 +0100

Aigars gravatar image

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 flag offensive 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

1 Answer

Sort by » oldest newest most voted

answered 2013-04-02 15:34:41 +0100

JohnSUN gravatar image

updated 2013-04-02 15:36:24 +0100

Try to use function N():

N(cell A)+N(cell B)-N(cell C)
edit flag offensive delete link more


Thanks, it works :)

Aigars gravatar imageAigars ( 2013-04-02 15:40:54 +0100 )edit

Question Tools


Asked: 2013-04-02 15:11:53 +0100

Seen: 2,081 times

Last updated: Apr 02 '13