Removing a 'FALSE' result
Solved/Closed
Related:
- Cashpot result
- Excel result sheet grade formula - Guide
- How to hide a google search result - Guide
- The following excel image has a vba program (see below). what will be the result after the program is executed? any cells not displayed are currently empty, and any cells with numbers are formatted numeric. sub afdo a=0 lastrow = cels(rows. count, 1). end(xdup). row for i =14 to lastrow step 2 a=a cellsii. 5) value next cells(lastrow 2, 1) value = "the sum - Guide
- Duckduckgo search result tabs - Guide
- How to save ping result in notepad - Guide
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Contributor
Last seen
December 27, 2022
555
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