1 x end salary = pensionable salary x pensionable years +r360

--

50

but this is only if a person is 60 years. Above benefits are reduced by .33% for each month between the members age and 60 years.

How can I use if statements to complete this formula in excel

--

50

but this is only if a person is 60 years. Above benefits are reduced by .33% for each month between the members age and 60 years.

How can I use if statements to complete this formula in excel