Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 150.01 *2 I have the labor formula and then the total is a sum formula. Please help with the price formula. Thank you. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Counting # of Formulas in a column with formulas and entered data | Excel Worksheet Functions | |||
ms-excel guidence notes, complete formulas in excel, How to runmacros in Ms excel | Excel Discussion (Misc queries) | |||
CELLS NOT CALC FORMULAS - VALUES STAY SME FORMULAS CORRECT?? HELP | Excel Worksheet Functions | |||
Copying formulas from Excel 2003 to Excel 2007 | Excel Discussion (Misc queries) | |||
Formulas not evaluated, Formulas treated as strings | Excel Discussion (Misc queries) |