In cell J3, use the IF function to calculate the retirement matching for each faculty member who is 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.
Solved by I. H. in 13 mins