IF formula question

[Guest]

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

 

[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
(e-mail address removed)
Replace@mailinator with @tiscali.co.uk

 

[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

 

[Guest]

Try this:

Cell A1 is the number of sheets.

=IF(A1<200,2,A1*0.01)