what IF forulma would be used for D)

le le Formatting as Table Styles Salary Inar Budgeted 2.50% Ravenue to Profiles to date HR Coats Productivity Revenge per 2012 Start Date Tenwo Status 34 2017 1 F 2017 1 F 28 2017 1 26 2015 3 F 24 2013 5 R 19 2015 F 18 2017 1 F 37 2001 17 R 32 2000 1 F 36 2017 1 F 24 2010 F 2017 1 F 23 2015 3 F 37 2014 4 F 3 2015 3 F 41 2010 2 F 32 F 28 2014 4 F 2016 2 31 2007 F 2018 2 F 35 2017 1 F 31 2015 3 R 2017 1 40 2017 20 2015 3 F 37 2011 7 F 2002 18 F 2008 10 23 2015 3 30 2010 2002 40 F 20 2017 1 F 30 2003 15 14 2005 13 29 aboa 10 R 30 19 Salary Salary Iner. Part Rating Days Absent 80000 2 0 85000 2 5 100000 3 30 45000 3 13 50000 2 8 41000 1 5 70000 2 20 75000 3 0 80000 3 3 70000 3 0 60000 2 5 60000 3 5 80000 3 3 65000 75000 15 100000 3 5 37000 2 4 20000 1 2 S0000 1 30 59000 2 4 60000 1 20 47000 3 6 100000 66000 2 1 75000 2 . 40000 2 7 100000 2 13 T0000 38000 3 48000 3 34000 2 10000 45000 2 10 100000 65000 100000 S 412 0 00 TO 00 5 1972 1190 1984 MacBook Air 000 FS 78 II F7 FB F10 ol d) Insert a column to the right of Salary, name the column Salary Incr. In cell K5 calculate a 2.5% increase in salary for all employees if they have a Performance Rating of greater than 1, otherwise leave the cell blank. Make sure the cell with the % Incr. value is absolute. Copy to remaining cells