IF formula question

B

Barb1

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
 
S

Sandy Mann

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

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

--
HTH

Sandy
[email protected]
Replace@mailinator with @tiscali.co.uk
 
A

Anne Troy

Not much info there, Barb. Assuming your $1.00 is in A1 and the $2.00 is in
B1, try this:
="For folding sheets of paper, the charge is "&A1&" per 100, with a "&B1&"
minimum."
************
Anne Troy
www.OfficeArticles.com
 
Top