Thanks, Duke. I tried your solution from the other day and it kept coming up
error in formula for some reason. However, what you posted today this seems
to be working.

Thanks, Barb

"Duke Carey" wrote:

From my answer to your same question 2 days ago

Try

=(2+((A1400)*0.5*(CEILING(A1/100,1)-4)))*(A10)

Which assumes that the charge for 400 is $2, but for 401 it's $2.5

Duke



"Barb1" wrote:

I have been working with this formula for two days and can't get it to work
right. Can anyone help?

The criteria is--If column A1 is less than 400 sheets, but not equal to 0,
then charge 2.00. If its more than 400 sheets, then charge is .50 per 100.
The difficulty has been charging .50 per 100 over 400 sheets. It needs to
charge in .50 increments.

Thanks,
Barb