Hi

Try this:
=IF(AND(A10,A1<400),2,2+INT((A1-400)/50))
This is presuming that when they buy over 400, they still pay the 2.00 for
the first 400.

--
Andy.


"Barb1" wrote in message
...
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