I'm sorry, Jack. Those kinds of formulas always baffle me, so while I can't
answer, I'm definitely watching for a resolution right along with you.
*******************
~Anne Troy

www.OfficeArticles.com


"jackoat" wrote in
message ...

Hi Anne / Arvi

Thank you for your help. I have solved the problem by using many nested
if statements. Anyway, i will also try both your suggested soultions. By
the way, I have another problem. Let's say an employer pays a worker an
additional amount - a certain % of his salary EVERY SINGLE MONTH into
three different accounts, A, B and C according to his age. For example,


for age 35-45, rate A = 10%, rate B= 8% and rate C=6%
age 45 - 55, rate A = 9%, rate B= 7%, rate C=5%
age 55 - 65, A= 7%, B = 5 %, C= 4%
age 65 - 75 A= 6%, B=4%, C= 3%

I am trying to calculate the total amount that an employee would have
received from his current age to a specified age. So, how much TOTAL
additional amount would the employee have accumulated in each of the
three accounts (i.e. total A, total B, total C) from his current age at
47 years 0 month to the specified age at 57 years 3 months? How should I
go about it? What functions can I use? The user would have to enter his
date of birth and the future age in question.

Hope you are able to help me this time as well. Thanks!!

Regards

Jack


--
jackoat
------------------------------------------------------------------------
jackoat's Profile:
http://www.excelforum.com/member.php...o&userid=25800
View this thread: http://www.excelforum.com/showthread...hreadid=392055