Ask Your Question

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

Comments

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?

( 2019-09-19 20:37:32 +0200 )edit

1 Answer

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