0 in cell if result is negative number
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.