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.
There was a solution posted before =max(A1-B1,0) but this doesn't seem to work in recent version.
Any ideas? Thank you!
I don't have the latest version of Numbers but MAX was one of the original functions from when spreadsheets first came out in the 1970's/1980's. Apple would not change how it works nor do I believe they would accidentally introduce a bug that would break it (though that is not a 100% certainty). Something else must be wrong.
Looks like a regional thing. If decimal numbers are written with comma for a decimal separator (1,23 not 1.23) then you need to use semicolons to separate the parameters in functions.
=MAX(A1-A2;0)
Possibly, but I cannot fathom what I am doing wrong.
You're a master - thank you ☃️
0 in cell if result is negative number
