G
Gifford Mom
I have a worksheet that we would like to use to calculate price + labor for
work. The price formula has me stumped. I would like to be able to put in the
price in one box and have the formula determine the amount at which to
multiply it by.
For example:
Price = 20.00 then the formula would determine how many to multiply it by
(3.25) from the range given below.
Range is 0-2.00 *4
2.01-5 *3.75
5.01-10 *3.5
10.01-20.00 *3.25
20.01-40 *3
40.01-60 *2.75
60.01-100 *2.5
100.01-150 *2.25
I have the labor formula and then the total is a sum formula. Please help
with the price formula. Thank you.
work. The price formula has me stumped. I would like to be able to put in the
price in one box and have the formula determine the amount at which to
multiply it by.
For example:
Price = 20.00 then the formula would determine how many to multiply it by
(3.25) from the range given below.
Range is 0-2.00 *4
2.01-5 *3.75
5.01-10 *3.5
10.01-20.00 *3.25
20.01-40 *3
40.01-60 *2.75
60.01-100 *2.5
100.01-150 *2.25
150.01 *2
I have the labor formula and then the total is a sum formula. Please help
with the price formula. Thank you.