I'm trying to nest greater than 7 arguments, based on a variable rate
structure. For example, there are 8 different age catories, and 9 different
rates... so depending on the person's age, i need to use a different rate. I
have successfully nested the maximum, but it leaves me with three age groups
that I can't calculate automatically.
Here is my formula so far:
=IF(F3>=70,Q3*VolLifeRates!$B$28,IF(F3>=65,Q3*VolLifeRates!$B$27,IF(F3>=60,Q3*VolLifeRates!$B$26,IF(F3>=55,Q3*VolLifeRates!$B$25,IF(F3>=50,Q3*VolLifeRates!$B$24,IF(F3>=45,Q3*VolLifeRates!$B$23,IF(F3>=40,Q3*VolLifeRates!$B$22,IF(F3>=40,Q3*VolLifeRates!$B$21,"manual calc."))))))))

It doesnt work or anyone under 40 so i have to manually calculate any
clients who's age is less than 40.

Grateful if you have a way around Microsoft's maximum!