I need this for the years 2017-2020. Please use the IF function

The actuary fo the pension plan of Regina Company calculated the follwoing net gains and losses Incurred during the Gain) or Loss S250,000 S400,000 ar 2017 (660,000) 2018 2019 2020 S1,000,000 Other information about the company's pension obligation and plan assets is as follows Market- related Plan Assets Value S3,400,000 3,640,000 3,900,000 4,360,000 Projected Benefit As of January 1 2017 2018 2019 2020 S4,000,000 4,500,000 4,900,000 5,250,000 Additional information is as follows: Labor force who are expected to receive benefits under the plan The total service-years for all participating employees The beginning balance of Accumulated OCI (G/L) on 1/1/17 The market-related value and the fair value of plan assets are the same for the 4-year period Use the average remaining service life per employee as the basis for amortization. 250 3,500 employees Instructions: 1. Compute the average remaining service life per umployee by filling up the shaded areas 2. Prepare a schedule which reflects the minimum amount of Accumulated OCI (G/L) amortized as a component of net periodic pension expense for each of the years 2017, 2018, 2019, and 2020 Apply the corridor approach in determining the amount to be amortized each year. Use -MAXMIN, FABSOLUTE, and lF functions to get to the answers. Identify whether the Minimum Amortization amount for each year is gain or loss. Using the parenthesis around the amount if it is a gain. Round to the nearest dollar 1. Average remaining service life per employee 2. Compute Accumulated 0C1(G/L). Fill in the shaded areas using the =MAX/MIN or =IF formulas when applicable: As of Projected JanuaryBenefit Plan Assets Value S3,400,000 Minimum Amortization of Gain/Loss Accumulated 10% $400,000 oCI (G/ 2017 $4,000,000 The actuary fo the pension plan of Regina Company calculated the follwoing net gains and losses Incurred during the Gain) or Loss S250,000 S400,000 ar 2017 (660,000) 2018 2019 2020 S1,000,000 Other information about the company's pension obligation and plan assets is as follows Market- related Plan Assets Value S3,400,000 3,640,000 3,900,000 4,360,000 Projected Benefit As of January 1 2017 2018 2019 2020 S4,000,000 4,500,000 4,900,000 5,250,000 Additional information is as follows: Labor force who are expected to receive benefits under the plan The total service-years for all participating employees The beginning balance of Accumulated OCI (G/L) on 1/1/17 The market-related value and the fair value of plan assets are the same for the 4-year period Use the average remaining service life per employee as the basis for amortization. 250 3,500 employees Instructions: 1. Compute the average remaining service life per umployee by filling up the shaded areas 2. Prepare a schedule which reflects the minimum amount of Accumulated OCI (G/L) amortized as a component of net periodic pension expense for each of the years 2017, 2018, 2019, and 2020 Apply the corridor approach in determining the amount to be amortized each year. Use -MAXMIN, FABSOLUTE, and lF functions to get to the answers. Identify whether the Minimum Amortization amount for each year is gain or loss. Using the parenthesis around the amount if it is a gain. Round to the nearest dollar 1. Average remaining service life per employee 2. Compute Accumulated 0C1(G/L). Fill in the shaded areas using the =MAX/MIN or =IF formulas when applicable: As of Projected JanuaryBenefit Plan Assets Value S3,400,000 Minimum Amortization of Gain/Loss Accumulated 10% $400,000 oCI (G/ 2017 $4,000,000