In cell S15: If the Year of Hire is before 1982, insert the value from cell M5, If the Year of Hire is before 1992, insert the value from cell M4 If the Year of Hire is before 2002, insert the value from cell M3, otherwise insert the value from cell M2. (Use absolute cell referencing where necessary). Copy the function down to the other cells. In S10 use the appropriate function to calculate the total for all employees. Format as comma style O decimal O # Rasing De bana Mare Cont Reeded Bertus 1 Deparat 1201 OBL OBE 015 170 10 OLET 1600 Anus Sud 0 MO 1. DIE 19.510 2010 3 ONI MED MEE . 1 CARO SO Far Com Front 750 taca 1221 9237 1.30 2.510 1 3 Ook Pin 410A 00 AR En OSE GO TI Ar TRE NA unt alla SHA AI des UNUSURISE DHE Ale De 1125 840 AD 2145 Junior JE AD SE M COT Tan LEEL 4 . BRID 10 DE 15 PALE 101 LATTE SOLE F 7 . EMA BE SU Min WO PVP 109 1 PE DI TE WE LED RE HA peep ner Mara hner 100 M 4 1 H PELLENTE w FORTE 101 RE tor Ta 10 PESE 1 1 M TU 61 14 5.316 UE BE 3.104 16.00 E 461 Du HO 1 WE PS SEL OPEE FALLE TAL 22721 TALS ITINTILATELE PANESE FALSE C 1 3 160 OS THE TRIE FILE ME TE TRUE TRISE sep CE M M OTIT 91 Vemhes 9 11. 44.7 74,58 NIE 7202 1356 1264 13 25 9111 5.74 RO 11 2162 14 a Rep 4 22 OR 59 SEM ULT n ET 1024 HUT ONE 17 DAMO M F QO Pand HERE 3 + 2 4 3 2 HD RSS TV 4 40 44 Sep wer Bay AR 4130 4333 4137 2 HOFTE 2015 FAL NITATE THE FALSE I FALSE TTTT Cam WE La Pet 30 4421 THE RE 2) 1.40 4.114 38 31 10 SEL COM RE SAM OT TEORI 2006 1372 F 7 M F Margar RA RGB TI 4 2 BO OBEC HILE 4,25 STE 3.30 TA 3. 4,501 586 The FALSE CHE DO EDE Bar 1 . LIT NO DE DOS M TW GOL VE 3211 10 FARE 21 ALTE SOFA 10 M41 REN M pool Hop WEE 5 2294 4.2731 In cell S15: If the Year of Hire is before 1982, insert the value from cell M5, If the Year of Hire is before 1992, insert the value from cell M4 If the Year of Hire is before 2002, insert the value from cell M3, otherwise insert the value from cell M2. (Use absolute cell referencing where necessary). Copy the function down to the other cells. In S10 use the appropriate function to calculate the total for all employees. Format as comma style O decimal O # Rasing De bana Mare Cont Reeded Bertus 1 Deparat 1201 OBL OBE 015 170 10 OLET 1600 Anus Sud 0 MO 1. DIE 19.510 2010 3 ONI MED MEE . 1 CARO SO Far Com Front 750 taca 1221 9237 1.30 2.510 1 3 Ook Pin 410A 00 AR En OSE GO TI Ar TRE NA unt alla SHA AI des UNUSURISE DHE Ale De 1125 840 AD 2145 Junior JE AD SE M COT Tan LEEL 4 . BRID 10 DE 15 PALE 101 LATTE SOLE F 7 . EMA BE SU Min WO PVP 109 1 PE DI TE WE LED RE HA peep ner Mara hner 100 M 4 1 H PELLENTE w FORTE 101 RE tor Ta 10 PESE 1 1 M TU 61 14 5.316 UE BE 3.104 16.00 E 461 Du HO 1 WE PS SEL OPEE FALLE TAL 22721 TALS ITINTILATELE PANESE FALSE C 1 3 160 OS THE TRIE FILE ME TE TRUE TRISE sep CE M M OTIT 91 Vemhes 9 11. 44.7 74,58 NIE 7202 1356 1264 13 25 9111 5.74 RO 11 2162 14 a Rep 4 22 OR 59 SEM ULT n ET 1024 HUT ONE 17 DAMO M F QO Pand HERE 3 + 2 4 3 2 HD RSS TV 4 40 44 Sep wer Bay AR 4130 4333 4137 2 HOFTE 2015 FAL NITATE THE FALSE I FALSE TTTT Cam WE La Pet 30 4421 THE RE 2) 1.40 4.114 38 31 10 SEL COM RE SAM OT TEORI 2006 1372 F 7 M F Margar RA RGB TI 4 2 BO OBEC HILE 4,25 STE 3.30 TA 3. 4,501 586 The FALSE CHE DO EDE Bar 1 . LIT NO DE DOS M TW GOL VE 3211 10 FARE 21 ALTE SOFA 10 M41 REN M pool Hop WEE 5 2294 4.2731