View Single Post
  #1   Report Post  
Barb1
 
Posts: n/a
Default IF Function in incremental charges

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