Multiple If Statements - Age and Income

[ligerdub]

Hi all,

I'm trying to generate a formula that captures a relevant charge payable on both age and income.

Basically the charges come down to the following:

If aged under 70:

Rate Income
2% up to 11,000
5% 11,000-15,000
9% 15,000

If aged over 70 you would pay:

Rate Income
2% Up to 11,000
5% Anything over 11,000

I have sorted the formula for those aged under 70....(letting E10 = income amount)

=IF(E10>=15000,0.09,IF(E10>11000,0.05,IF(E10<=11000,0.02,0)))

However, I don't know how to put in the formula to reflect the additional conditions based on age. Can anyone help me with this?

Many thanks.

[abousetta]

Maybe something like this:

Please Login or Register  to view this content.

abousetta

[ligerdub]

Would that work for both age and income attributes? Bearing in mind the age factor means the income impact is different for both.