Use this code

=IF(ISBLANK(A1),"",IF(A1<=49.95,12.48,A1*0.5))

ADC76 wrote:
Hey FSt1,
You and Jacob Skaria were both right, based on the information I gave you.
however the problem is now that 12.48 shows up even when A1 is blank. How do
I get B1 to stay blank unless data is entered in? Thanks for your help.
ADC76

hi
first, your formula is confusing, on really reflecting you discriptive need.
[quoted text clipped - 18 lines]
Thanks,
ADC76

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200905/1