Ask Your Question

Issue with calc formula

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

kcallis gravatar image

I create a column that should sums up all of the values and with the total, subtract 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 flag offensive close merge delete



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?

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

1 Answer

Sort by » oldest newest most voted

answered 2019-09-19 17:19:33 +0200

kompilainenn gravatar image

you can use condition like =if(sum(B2:B32)>0;sum(B2:B32-11.3%);0)

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


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

Seen: 37 times

Last updated: Sep 19