IF formula question
 

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

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

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

"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

Try this:

Cell A1 is the number of sheets.

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



"Barb1" wrote:

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