I need a formula to calculate rates based on current age
 

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

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

I need a formula to calculate rates based on current age
 

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

I need a formula to calculate rates based on current age
 

use a LOOKUP formula or a CHOOSE formula

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"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