Removing a 'FALSE' result
Solved/Closed
Related:
- Removing a 'FALSE' result
- Removing redirect - Guide
- Ping result to text file - Guide
- How to remove a number from blacklist - Guide
- You disagreed with the decision check back here for the result. - Facebook Forum
- Our system flagged your account activity as a violation of our terms of service and banned your phone number. your account will remain banned as a result of the violation. - WhatsApp Forum
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
552
Jul 24, 2018 at 12:06 PM
Jul 24, 2018 at 12:06 PM
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
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
Jul 24, 2018 at 12:10 PM
Enjoy the day,
Andrew