Removing a 'FALSE' result [Solved]

Andrew - Jul 24, 2018 at 12:01 PM - Latest reply:  Andrew
- Jul 24, 2018 at 12:10 PM
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?
See more 

Your reply

2 replies

TrowaD 2408 Posts Sunday September 12, 2010Registration dateModeratorStatus August 9, 2018 Last seen - Jul 24, 2018 at 12:06 PM
0
Thank you
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
Respond to TrowaD