(Excel 2013)
Hi,
I want to reference different cells in a table based on certain criteria: ex. If "insert numeric age" is less than 60, then (cell reference), however if age is greater than 60 but less than 76, (cell reference), if age is greater than 70, (cell reference).
Hope that makes sense.
Basically I want to enter a date of birth on my spread sheet (I already have a formula to calculate the age) and then use that age to determine the "full retirement age" of that individual based on a table elsewhere in the spreadsheet.
Thanks in advance!
(see attachment for more context)
Bookmarks