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