M
Martha
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(E22>70,"2.01",IF(E22>65,"1.24",IF(E22>60,".66",IF(E22>55,".43",IF(E22>50,".23",IF(E22>45,".15",IF(E22>40,".10",IF(E22>35,".09",".07"))))))))
Two additional arguments need to be added. Help
following, which works but I have more age catagories that need to be added
=IF(E22>70,"2.01",IF(E22>65,"1.24",IF(E22>60,".66",IF(E22>55,".43",IF(E22>50,".23",IF(E22>45,".15",IF(E22>40,".10",IF(E22>35,".09",".07"))))))))
Two additional arguments need to be added. Help