Removing a 'FALSE' result
Solved/Closed
Related:
- Removing a 'FALSE' result
- Ping result to text file - Guide
- Windows defender not removing threat ✓ - Viruses & Security Forum
- Removing redirect - Guide
- How to remove false in excel ✓ - Excel 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
January 16, 2023
549
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