You can make a difference in the Apple Support Community!
When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
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
