Another "IF' question

[Guest]

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

 

[Guest]

If the number is in A10, use this:

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

Eric

 

[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

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

 

[Ron Rosenfeld]

If the number is in A10, use this:

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

Eric

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


--ron