In cell J3, use the IF function to calculate the retirement matching for each faculty member participating in the retirement plan For participating members, the function should multiply their salary by the retirement matching percentage For all other members, the function should return 0 Be sure to make the reference to cell J1 an absolute reference in the function Use the fill handle to copy the function down through the column Apply the currency format to the values and align the text to the right of the cell Retirement Matching 4 00 Retirement Matching $ Salary Plan LastName FirstName Department Rank From Young Jeft Management Assistant Austin TX Parker Mathew Accounting Full Profe Miami FL Nelsen Beth Finance Full Profe Columbus OH Smith Tom Finance Full Profe Odessa TX Jacobson Andrew Management Full Profe Memphis TN Rais Mary Finance Instructor Macon GA Participates in Retirement Year Hired Gender 2001 M $ 47,763 Yes 1985 M $62,142 Yes 1988 F $56,589 Yes 1983 M $61,417 Yes 1982 M $60,531 Yes 2004 F $31,250 No

The Answer is in the image, click to view ...

Question: In cell J3, use the IF function to calculate the retirement matching for each faculty member participating in the retirement plan. For participating members, the

In cell J3, use the IF function to calculate the retirement matching for each faculty member participating in the retirement plan. For participating members, the function should multiply their salary by the retirement matching percentage. For all other members, the function should return 0. Be sure to make the reference to cell J1 an absolute reference in the function. Use the fill handle to copy the function down through the column. Apply the currency format to the values and align the text to the right of the cell.

In cell J3, use the IF function to calculate the

Retirement Matching % 4.00% Retirement- Matching $ Salary Plan LastName FirstName Department Rank From Young Jeft Management Assistant Austin TX Parker Mathew Accounting Full Profe: Miami FL Nelsen Beth Finance Full Profe: Columbus OH Smith Tom Finance Full Profe: Odessa TX Jacobson Andrew Management Full Profe: Memphis TN Rais Mary Finance Instructor Macon GA Participates in Retirement Year Hired Gender 2001 M $ 47,763 Yes 1985 M $62,142 Yes 1988 F $56,589 Yes 1983 M $61,417 Yes 1982 M $60,531 Yes 2004 F $31,250 No

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

On the Instructor Data worksheet, in cell J 3 , use an IF function nested with Vlookup function to calculate the retirement matching amount for each instructor. For an instructor who participates in...

Switch to the Faculty Data worksheet. Use one of the Excel functions that we have seen to complete the worksheet by calculating the matching retirement dollar amount for each faculty member (column...

Please help! I really just need to know the function to use in #3 3) Switch to the Faculty Data worksheet. Use one of the Excel functions that we have secn to complete the workshect by calculating...

An Overview of TRS and ORP for Employees who are Eligible to Elect ORP Retirement Plan Options You have a choice to make between two different retirement plans. * TRS: All TRS-eligible employees at...

1 Start Excel, and then open the downloaded file last_exc_ch5-6_ _df.xlsx. (Srader has automatically added your last name to the beginning of the filename. Save the file to the location where you are...

troduction: In this tab assignment you will create a household budget for yourself using Microsoft Excel A budget is an estimate of expected revenues and expenses for a period of time Follow these...

SUMMARY OF LEARNING OBJECTIVES AND KEY POINTS 1. Identify the basic elements of organizations. Organizations are made up of a series of elements: Designing jobs Grouping jobs Establishing reporting...

B 1 1 M r Category Type 1 F 2 3 H Base case city Houston Comparison city Lubbock H Living Factor 6.30% 28.20% 13.40% -4.60% 0.00% 33.6.21% HC 5 Food & Groceries Housing Health care Miscellaneous...

Pick a case and become familiar with the case requirements. Use what you learned on chapter 19. For formatting, use times new roman 12 pt font and double space your answers. You must include...

I need step by step instruction and formulad on excel RETIREMENT PLANNING (Source: Powell \& Baker, Management Science, 2007) Bob Davidson is a 46-year-old tenured professor of marketing at a small...

Specify a non-norm function in R. Explain why the function you describe is not the norm.

At the end of the year, Providence Properties statement of cash flows reported the following for investing activities: Requirement 1. For each item listed, make the journal entry that placed the item...

The 3 rd step of latane and darley's 5 steps to helping is: accept responsibility to help interpret the event as an emergency know how to help call for professional medical / rescue help ( 9 1 1 )

atch the compensation objectives with their meanings. Efficiency Efficiency drop zone empty. Fairness Fairness drop zone empty. Compliance Compliance drop zone empty. Improving performance and...