Removing a 'FALSE' result [Solved]

Andrew - Jul 24, 2018 at 12:01 PM - Latest reply:  Andrew
- Jul 24, 2018 at 12:10 PM

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


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 2435 Posts Sunday September 12, 2010Registration dateModeratorStatus October 8, 2018 Last seen - Jul 24, 2018 at 12:06 PM
Thank you
Hi Andrew,

Take a look at the last part:

The false statement is between the last 2 brackets, which is empty, thus getting a FALSE.
Change it into this:

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

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

Enjoy the day,
Respond to TrowaD