I need a formula to calculate rates based on current age
Martha,
I suggest this is done with a table instead. Create a table of your values
like the one I have part created he-
0 7
36 9
41 10
46 15
Note it must be laid out ascending in the left column. then use the formula:-
=VLOOKUP(E22,A1:B4,2,TRUE)
It will check E22 and return the value from Column 2 of the table
Mike
"Martha" wrote:
I am calculate benefit rates based on current age. I have entered the
following, which works but I have more age catagories that need to be added.
=IF(E2270,"2.01",IF(E2265,"1.24",IF(E2260,".66" ,IF(E2255,".43",IF(E2250,".23",IF(E2245,".15",I F(E2240,".10",IF(E2235,".09",".07"))))))))
Two additional arguments need to be added. Help
|