With the below G7:G10 with two If's work fine. I'm trying to add a third IF in G6 which I will copy down but it is not giving me the required results.
What am I'm missing. I've searched and tried all kinds of formulas but can't get it to return the right results.
What am I'm missing. I've searched and tried all kinds of formulas but can't get it to return the right results.
| Excel 2010 | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|
| A | B | C | D | E | F | G | H | |||
| 3 | ||||||||||
| 4 | ||||||||||
| 5 | DATE | NAME | HOURS | RATE | % | AMOUNT | ||||
| 6 | JOB NAME | EMPLOYEE 1 | 8 | 16 | 0.262295082 | 128.00 | ||||
| 7 | JOB NUMBER | EMPLOYEE 2 | 8 | 13 | 0.213114754 | 104.00 | ||||
| 8 | LABOR CODE | EMPLOYEE 3 | 8 | 11 | 0.180327869 | 88.00 | ||||
| 9 | BUDGET AMOUNT | EMPLOYEE 4 | 8 | 10 | 0.163934426 | 80.00 | ||||
| 10 | OVER TIME | 1.5 | EMPLOYEE 5 | 8 | 11 | 0.180327869 | 88.00 | |||
| 11 | 0 | |||||||||
| 12 | 61 | |||||||||
Sheet1 | ||||||||||
| Cell Formulas | ||
|---|---|---|
| Range | Formula | |
| F6 | =E6/$E$12 | |
| F7 | =E7/$E$12 | |
| F8 | =E8/$E$12 | |
| F9 | =E9/$E$12 | |
| F10 | =E10/$E$12 | |
| F11 | =E11/$E$12 | |
| G6 | =IF($B$9<1,D6*E6,IF($B$9>1,$B$9*F6,IF(B10>0,B10*E6*D6,0))) | |
| G7 | =IF($B$9<1,D7*E7,IF($B$9>1,$B$9*F7,D7*E7)) | |
| G8 | =IF($B$9<1,D8*E8,IF($B$9>1,$B$9*F8,D8*E8)) | |
| G9 | =IF($B$9<1,D9*E9,IF($B$9>1,$B$9*F9,D9*E9)) | |
| G10 | =IF($B$9<1,D10*E10,IF($B$9>1,$B$9*F10,D10*E10)) | |
| E12 | =SUM(E6:E11) | |
