Thread
:
I need a formula to calculate rates based on current age
View Single Post
#
4
Posted to microsoft.public.excel.worksheet.functions
Don Guillett
external usenet poster
Posts: 10,124
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
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett