Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculate date when funds run out based on current usage | Excel Discussion (Misc queries) | |||
Formula to calculate the current year | Excel Discussion (Misc queries) | |||
Current date formula based on month | Excel Discussion (Misc queries) | |||
How can I calculate trend growth rates in Excel? | Excel Discussion (Misc queries) | |||
how do i calculate pay from given hours and pay rates? | Excel Worksheet Functions |