Looking at your data table below you seem to be starting from the wrong
place. For example yo have a column 'Months Registered' that contains a
number of months. If you approach it that way it will be wrong next month.

What you need is 2 tables:-

Customer - Date registered - Months registered

Bloggs 1/6/2007 =MONTH(NOW())-MONTH(b2)

Month regsitered now updates automatically.

In a second table you need:-

Months - Discount
5 5%
10 10%
15 12%
20 15%

A simple Vlookup now calculates the discount per Customer

=VLOOKUP(C2,A1:B9,2,TRUE)


Where c2 is the months registered.
a1:b9 is the discount table
True makes it return the nearest value if there isn't an exact match.


Mike
"mda19652" wrote:

I am having difficulty creating a formula. My list has clients who has been
with a company for x number of months. Depending on how long they have been
clients, results how much discount they receive.

eg:

A B C D E
FIRST LAST MTHS MTHS PERCENTAGE
REGD
Joe Blog 19 5 5%
10 10%
15 12%
20 15%

Can anyone help me?

Many thanks,
Marty