# 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.

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?