Another "IF' question

B

Barb1

Please help create a formula for this situation:

We charge for perforating paper 15.00 per 1000; with a minimum of 15.00 so
anything 0-1000 is $15, 1001-2000 is $30, etc.

Thanks,
Barb
 
R

Ron Rosenfeld

Please help create a formula for this situation:

We charge for perforating paper 15.00 per 1000; with a minimum of 15.00 so
anything 0-1000 is $15, 1001-2000 is $30, etc.

Thanks,
Barb
Click to expand...

Your example suggests that the minimum charge is $15 for each 1000 sheets **or
fraction thereof**.

That being the case:

=CEILING(A1/1000*15,15)


--ron
 
R

Ron Rosenfeld

If the number is in A10, use this:

=(ROUNDDOWN(A10/1000,0)+1)*15

Eric
Click to expand...


Your formula gives $15 for 0 sheets; $30 for 1000 sheets; etc -- not what the
OP requested.


--ron
 
Top