Thanks Mama! This is kind of what I did before. If the sale is 0, the
equation below is returning a fee of 30 cents. Should I add an IF clause at
the beginning?

Leslie

Teethless mama wrote:
=LOOKUP(A1,{0,0.01,3000.01,10000.01,100000.01},{0 ,0.029,0.025,0.022,0.019})*A1+0.3

Hi,

[quoted text clipped - 12 lines]
Thanks,
Leslie

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