I have a simple subtraction formula.
SUM=A1-A2
Sometimes that reflects a negative number IF it's negative I want to know the result. (245) or -245
If it's Positive I want to see a zero in that cell.
Is this possible? I'm sure this is super simple for someone but I can't figure it out.
If your result of A1-A2 is in, say, A3, then you could use:
=MIN(0,A3)
Or, if you want to do it directly without having the result in a different cell:
=MIN(0,A1-A2)
Note you could also use an IF formula, but that is more complicated.
Use ; instead of , in the formulas if your region uses , as a decimal separator.
SG
If your result of A1-A2 is in, say, A3, then you could use:
=MIN(0,A3)
Or, if you want to do it directly without having the result in a different cell:
=MIN(0,A1-A2)
Note you could also use an IF formula, but that is more complicated.
Use ; instead of , in the formulas if your region uses , as a decimal separator.
SG
Show positive numbers as zero OR show the negative result
