"IF" formula question

B

Barb1

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

The criteria is--If less than 400 pages, but not equal to 0, then charge
2.00 minimum. If more than 400 pages, then charge is .50 per 100.

Thanks,
Barb
 
D

Duke Carey

Try

=(2+((A1>400)*0.5*(CEILING(A1/100,1)-4)))*(A1>0)

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

Duke
 
Top