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

Assuming that you want part 100's rounded up to the next 100,

=IF(A1="","",MAX(2,CEILING(A1,100)/100))

--
HTH

Sandy

Replace@mailinator with @tiscali.co.uk

"Barb1" wrote in message
...
I need a formula for this situation.

For folding sheets of paper, the charge is 1.00 per 100, with a 2.00
minimum
charge.

Thanks,
Barb