Issue with calc formula

I create a column that should sums up all of the values and with the total, subtract 11.3

=sum(b2:B32)-11.3%

I noticed that if I remove all of the values in the column, the cell that held the formula will show a negative number. Why does the cell show any value if all of the other cells are blank. I should point out that I have the number format set for currency.

edit retag close merge delete

1

Hello kcallis, your question of why the cell shows a value if you put all other cells to zero indicates that you might mistake what your formula calculates. The fomula is correct if B2:B32 contain % values. But if you wanted to calculate your sum minus 11.3% of e.g. the sum, then your result is wrong. And that's also the reason why the cell shows a value (I'd guess depending on the format -11.3% or -0.113). You could also write =SUM(B2:B32)-0.113. What is your objective? The question is minus 11.3% of what?

Sort by » oldest newest most voted you can use condition like =if(sum(B2:B32)>0;sum(B2:B32-11.3%);0)

more

Stats

Asked: 2019-09-19 17:11:59 +0200

Seen: 37 times

Last updated: Sep 19