Function Help

[bisdobc]

in this formula, =IF(D19>=159,16,IF(D19>=120,8,IF(D19>=108,4,IF(D19>=1,2)))) Is there a way to change the text from displaying the total or FALSE? I would like the cell to be blank. Tried the CSE to rewrite the function still happened....

 

[AJ]

Try adding what you want to display instead of FALSE in the very last IF, i.e.

=IF(D19>=159,16,IF(D19>=120,8,IF(D19>=108,4,IF(D19>=1,2,""))))

Rgds
AJ

 

[bisdobc]

Thank you AJ for your time and help!!!
I did use that feature and also created redundancy
=IF(D11>=159,16,IF(D11>=120,8,IF(D11>=108,4,IF(D11>=1,2,IF(D11=0, )))))
Still a "0" is put in the cell that is better than screaming FALSE
Thank you again swak!