Removing a 'FALSE' result [Solved/Closed]

Report
-
 Andrew -
Hello,

In the following formula, I am getting a 'FALSE' as opposed to a '0' result.

=IF((F28+F31)<$K$8,MAX(0,$K$8-(F28+F31),0))

My reason for using the 'MAX' formula is to avoid getting negative numbers...there may be a better way of doing this...but my main issue is the 'FALSE' issue.

Any suggestions?

1 reply

Posts
2757
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
June 8, 2021
462
Hi Andrew,

Take a look at the last part:
MAX(0,$K$8-(F28+F31),0))

The false statement is between the last 2 brackets, which is empty, thus getting a FALSE.
Change it into this:
MAX(0,$K$8-(F28+F31)),0)

Always double check your bracket placement in nested formula's.

Best regards,
Trowa
Brilliant!!! Thank you so much, Trowa!

Enjoy the day,
Andrew

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!