I have 14 different IF formulas I am trying to combine. They are all different calculations (see below). For now I have each formula in a different column and then a new column which adds the values on each row to get one column with all the numbers I need (each row will only have one value). Is there a better way to do this?

```
L Column =IF(K2="Regular",H2,IF(AND(K2="Regular Attendance Penalty",E2="TEMPRILEY"),(H2/1.38)-1)*1.38)
M Column =IF(AND(K2="Regular Attendance Penalty",E2="TEMPTRC"),(H2/1.4)-1)*1.4
N Column =IF(AND(K2="Overtime",E2="TEMPTRC"),(H2/1.5)*1.25)
O Column =IF(AND(K2="OT Regular Attendance Penalty OT",E2="TEMPTRC"),(H2/1.4)-1)*1.4*1.25
P Column =IF(AND(K2="Regular Attendance Penalty",E2="TEMPINT"),(H2/1.4)-1)*1.4
Q Column =IF(AND(K2="Overtime",E2="TEMPINT"),(H2/1.5)/1.4)*1.5*1.34)
R Column =IF(AND(K2="OT Regular Attendance Penalty OT",E2="TEMPRILEY"),(H2/1.38)-1)*1.5*1.38
S Column =IF(AND(K2="Overtime",E2="TEMPRILEY"),H2)
T Column =IF(AND(K2="OT Regular Attendance Penalty OT",E2="TEMPINT"),(H2/1.4)-1)*1.5*1.34
U Column =IF(AND(K2="Regular 2nd Shift Attendance Penalty",E2="TEMPINT2nd"),(H2/2/1.4)-0.75)*1.4
V Column =IF(AND(K2="Regular 2nd Shift Attendance Penalty",E2="TEMPTRC2nd"),(H2/2/1.4)-0.75)*1.4
W Column =IF(AND(K2="Regular 2nd Shift Attendance Penalty",E2="TEMPRILEY2nd"),(H2/2/1.38)-0.75)*1.38
X Column =IF(AND(K2="Regular Shift 2",E2="TEMPTRC2ND"),H2)
Y Column =IF(AND(K2="Regular Shift 2",E2="TEMPINT2ND"),H2)
X Column =IF(AND(K2="Regular Shift 2",E2="TEMPRILEY2ND"),H2)
```

`((H2/1.38)-1)*1.38`

is`H2-1.38`

to within round-off error;`(H2/1.5)*1.25`

is`H2*5/6`

,`((H2/1.5)/1.4)*1.5*1.34`

is`(H2/1.4)*1.34`

which is`H2*1.34/1.4`

or`H2*67/70`

, etc. – Scott Dec 28 '18 at 21:43