# Re: Why does Formulae calculate Minus Zero?

Solved
451 0
cancel
Showing results for
Did you mean:
5 - Automation Enthusiast

I used a simple formula for column C (it is A-B), it shows up as -0 in one case and 0 for another? Why should zero have a negative sign?

In my case although all 3 columns are setup to round to 2 digits, I am certain that there is no third decimal digit in either column A or B.

Reason for asking is that it messes my colour codes where I’ve setup anything less than zero as red.

1 Solution

Accepted Solutions
14 - Jupiter

Even though you are rounding the display of `A` and `B` in their fields, Airtable still holds the full float in the background - down to the greatest level of specificity the float originally went to.

For better or for worse (probably for better), when you perform calculations via formulas on a number field that you have rounded in the display, the formula acts on the float behind the display, not the displayed/rounded version.

So, in your `(A - B)` formula, try rounding the end result of the calculation like this: `ROUND(A - B)`.

If that still displays a negative `0`, try rounding each number involved in the calculation like this: `ROUND(A) - ROUND(B)`.

Even though you are rounding the display of `A` and `B` in their fields, Airtable still holds the full float in the background - down to the greatest level of specificity the float originally went to.
So, in your `(A - B)` formula, try rounding the end result of the calculation like this: `ROUND(A - B)`.
If that still displays a negative `0`, try rounding each number involved in the calculation like this: `ROUND(A) - ROUND(B)`.