IF SUM ends in a negative then should equal zero

How to zero off a total when sum equals negative


solution


(MAX(SUM(value))-(SUM(value)),0)





Posted on Feb 2, 2025 3:43 AM

Reply
Question marked as Top-ranking reply

Posted on Feb 3, 2025 10:05 PM

One way is to use MAX.


=MAX(<your original formula goes here>,0)


SG



1 reply

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

IF SUM ends in a negative then should equal zero

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.