Hey Andy,
That formula works too. However, I seemed to have created another problem
by entering this formula. Here is the post that I replied to Jacob, but have
not heard back from him yet. Maybe you can help.

"Unfortunately it seems to be throwing of the calcuations of another cell
all together. I'm now getting a #VALUE error message in my totals cell on on
that row. That cell's formula is:
H1+B1+C1+D1+E1+F1
The results show in I1. Only when all cells are blank do I get the #VALUE
error. If data is entered in any cell of Row 1, the formulas work fine.
However, I have a cell at the bottom of column I that is to total all data in
that column, and that formula is not working at all. =SUM(I1:I30)
Thanks for your help."
ADC76


"Andy_N1708 via OfficeKB.com" wrote:

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