Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF Formulas
I need help building a formula for payouts
Basic Stretch Super Strech 63 $3.00 72 $5.00 82 $7.00 employee 1 has 85 employee 2 has 72 employee 3 has 71 (if employee is under 63 then there is no payout = $0.00) -- Still Learning... |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF Formulas
I would set it up as follows let's say starting in A1:
Super Stretch 82 7 Stretch 72 81 5 Basic 63 71 3 None 0 62 0 The below would start in A7: Employee 1 85 Employee 2 72 Employee 3 71 The below formula would be in cell C7 =IF(B7=$B$1,$D$1,IF(B7=$B$2,$D$2,IF(B7=$B$3,$D$ 3,IF(B7=$B$4,$D$4)))) ":: Amy ::" wrote: I need help building a formula for payouts Basic Stretch Super Strech 63 $3.00 72 $5.00 82 $7.00 employee 1 has 85 employee 2 has 72 employee 3 has 71 (if employee is under 63 then there is no payout = $0.00) -- Still Learning... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Counting # of Formulas in a column with formulas and entered data | Excel Worksheet Functions | |||
CELLS NOT CALC FORMULAS - VALUES STAY SME FORMULAS CORRECT?? HELP | Excel Worksheet Functions | |||
automatically copy formulas down columns or copy formulas all the | Excel Worksheet Functions | |||
Formulas not evaluated, Formulas treated as strings | Excel Discussion (Misc queries) | |||
formulas for changing formulas? | Excel Discussion (Misc queries) |