If those are rates you should remove all the quotation marks since those
make the values text and not numbers, anyway you can bypass IF limits by
using a lookup formula, this will do exactly the same as your posted formula
and it can be amended

=VLOOKUP(E22,{0,0.07;36,0.09;41,0.1;46,0.15;51,0.2 3;56,0.43;61,0.66;66,1.24;71,2.01},2)



--
Regards,

Peo Sjoblom



"Martha" wrote in message
...
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