Change formula to
=IF(ISBLANK(A1),0,IF(A1<=20,12,A1*0.5))

ADC76 wrote:
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

Use this code

[quoted text clipped - 11 lines]
Thanks,
ADC76

--
Message posted via http://www.officekb.com