Removing a 'FALSE' result
Solved/Closed
Related:
- Removing a 'FALSE' result
- Result formula in excel marksheet - Guide
- Removing redirect virus - Guide
- How to remove a story from close friends - Instagram Forum
- How to remove a number from blacklist - Guide
- How do i undo removing my username link from someone else’s bio on instagram? - Instagram 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