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?
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?