This is my first post on here, so my apologies if this has been answered before. I am struggling with how to phrase my question so googling for an answer has not been terribly successful.
Anyhow, I am building a spreadsheet to calculate annual updates to pensions, and the calculation changes when someone turns 60 or 65.
In short, I want a formula that will reference a cell containing the age, and if under that age does one calculation, and if over, another calculation.
If column A contains 'pension', B contains 'age' and C contains sex (M/F), I want column D to show the answer to A x E, or A x F, depending on whether the value in B is 60 or over (if female), or if B is 65 or over (if Male).
The age at which the calculation changes basis is 60 for female and 65 for male, so if the calculation could also recognise the content of column C and act accordingly, that would be marvellous. Otherwise, I would stick with a separate worksheet for each sex and a simpler formula.
Hopefully this makes sense. I am grateful for your help.
Anyhow, I am building a spreadsheet to calculate annual updates to pensions, and the calculation changes when someone turns 60 or 65.
In short, I want a formula that will reference a cell containing the age, and if under that age does one calculation, and if over, another calculation.
If column A contains 'pension', B contains 'age' and C contains sex (M/F), I want column D to show the answer to A x E, or A x F, depending on whether the value in B is 60 or over (if female), or if B is 65 or over (if Male).
The age at which the calculation changes basis is 60 for female and 65 for male, so if the calculation could also recognise the content of column C and act accordingly, that would be marvellous. Otherwise, I would stick with a separate worksheet for each sex and a simpler formula.
Hopefully this makes sense. I am grateful for your help.