Computing price based upon various quantities

T

Tim McBrayer

I am looking for the right formula to compute a total price of a
project where the two variables are the quantity of items being used in
the project and the price per item that varies according to how many
items are used in the project. So if the customer submits <26 items the
cost is $150 for the project; from 26 to 50 the cost is $6.00 per item;
from 51-100 the cost is $6.50 per item and >100 items the cost is $6.75
per item. I just can't figure out how to have one field for the number
of items and then have a second field that computes what the total cost
is going to be. Can anyone explain how to do set up the correct formula?
 
B

Bob Greenblatt

I am looking for the right formula to compute a total price of a
project where the two variables are the quantity of items being used in
the project and the price per item that varies according to how many
items are used in the project. So if the customer submits <26 items the
cost is $150 for the project; from 26 to 50 the cost is $6.00 per item;
from 51-100 the cost is $6.50 per item and >100 items the cost is $6.75
per item. I just can't figure out how to have one field for the number
of items and then have a second field that computes what the total cost
is going to be. Can anyone explain how to do set up the correct formula?
Assuming the Price per item is in column A, and the Quantity is in B. But,
your explanation is confusing. Is the price per item fixed as per your
explanation, or does it vary based on the value in the price column? If
fixed, the formula would be:

=if(b1<26,150,if(b1<51,6*b1,if(b1<101,6.5*b1,6.75*b1)))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top