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.
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?
you can use condition like =if(sum(B2:B32)>0;sum(B2:B32-11.3%);0)