Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

what IF forulma would be used for D) image text in transcribed
image text in transcribed
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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Costing

Authors: Terry Lucey

6th Edition

0826455107, 9780826455109

More Books

Students also viewed these Accounting questions