You're welcome!

ADC76 wrote:
Hey Andy,
Just wanted to let you know that I tried plugging in your formula one more
time and tweeked it a little with the right numbers and it worked! The
#VALUE error went away and I duplicated the formula down the column and my
totals cell in I31 working properly.
Thanks for the help!
ADC76

Change formula to
=IF(ISBLANK(A1),0,IF(A1<=20,12,A1*0.5))
[quoted text clipped - 20 lines]
Thanks,
ADC76

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