"IF" formula question
 

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

Hi Barb

=IF(A1=0,"",IF(A1<400,2,A1/100*.5))

--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"Barb1" wrote in message
...
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

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 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