Function Help

bisdobc · Apr 12th, 2002, 09:31 AM

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 · Apr 12th, 2002, 09:34 AM

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 · Apr 12th, 2002, 09:54 AM

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!

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 12th, 2002, 09:31 AM	#1
bisdobc New Member Join Date: Apr 2002 Location: boise Posts: 2	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....

Apr 12th, 2002, 09:34 AM	#2
AJ Board Regular Join Date: Mar 2002 Location: =ActiveCell.Address Posts: 478	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

Apr 12th, 2002, 09:54 AM	#3
bisdobc New Member Join Date: Apr 2002 Location: boise Posts: 2	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!