Need to convert formula to Excel 2007 format for nested IFS

Hi,

I have a spreadsheet I developed in Excel 2010 with nested if functions. When I try to save it in 2007.xls format, it says too many nested if functions and it is not supported. I need this formula converted to be compatible with excel 2007.xls

See attached worksheet. This is the formula highlighted in orange that works now in Excel 2010. This formula is accounting for early or late retirement age regarding social security benefits and uses a benefit table as the reference. The current formula accounts for both early and late retirement as one function. Perhaps I could break it into 2 parts using an "OR" statement???

=IF(C9<62,0,IF(C9>=70,B22*1.24,IF(C9=69,B22*1.16,IF(C9=68,B22*1.08,IF(AND(C9<C10,C9<=62),B22*0.7,IF(C9<=63,B22*0.75,IF(C9<=64,B22*0.8,IF(C9<=65,B22*0.877,IF(C9<=66,B22*0.933,B22)))))))))

c9= age @ retirement
c10 = full retirement age
b22 = mthly benefit high earner

Thanks
HR

************************
=IF(C9<=61,0,CHOOSE(MIN(10,MAX(1,C9-60)),$B$22*0.1,$B$22*0.7,$B$22*0.75,$B$22*0.8,$B$22*0.877,$B$22*0.933,$B$22,$B$22*1.08,$B$22*1.16,$B$22*1.24))

I would tend to use a lookup table rather than a series of nested ifs. https://support.office.com/en-us/art...8-93a18ad188a1

Put all of your ages in one column, put the desired outputs in an adjacent column, then work out the VLOOKUP() function that will return the desired value for the desired age.