View Single Post
  #2   Report Post  
JulieD
 
Posts: n/a
Default

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