Help with nested IF statement

[mrafiq44]

Employee A , aged 62 is in a pension plan, the rules of which in 2015 were: Payout = 1/2 of Salary or 15000 whichever is less, in 2019, the rules changed payout = 1/2 of Salary or Social Security limit whichever is less

but if Employee A is above the age of 62, the rule has always been payout = 1/2 of Salary or $30,000 whichever is less

I need to create 2 if's statement showing that if i have the age, salary and social security limit i can derive the payout number for years 2015 and then one for 2019 for employee above and below the age of 62.

Additional question:
Can there be if possible only one if statement for the age and the different year rules?

Any help would be greatly appreciated.

 

[kweaver]

If A2 is age; b2 is salary; c2 is SS Limit, then

D2: =MIN(15000,B2) for 2015 pension and
E2: =IF(A2>62,MIN(30000,B2),MIN(B2,C2)) for 2019 pension

Is this what you mean?

 

[mrafiq44]

If A2 is age; b2 is salary; c2 is SS Limit, then

D2: =MIN(15000,B2) for 2015 pension and
E2: =IF(A2>62,MIN(30000,B2),MIN(B2,C2)) for 2019 pension

Is this what you mean?

can i do both under the age of 62 and above the age of 62 in one cell for 2015 and in one cell for 2019?

 

[kweaver]

What happens in 2015 if under 62?

D2: =IF(A2<=62,whatever,MIN(15000,B2)) for 2015 pension [does this include age 62 or should the other one have an = in it?]