Hi Dexter

with number of months in A1 and current rate in B1
one option would be
=IF(A1<36,B1*0.7,IF(A1<=48,B1*0.8,B1*0.9))

Cheers
JulieD


"Dexter" wrote in message
...
Good morning all!

I need help creating an equation that will do the following.

Here is a line out of a contract that our company has just won. I have a
spreadsheet currently of the current rate, and also the # of months that
the
machine has been in place for. However, I'm not sure how to create a
statement based on the following:

Curently placed units in service less than 36 months: 30% discount from
current rate

Units in service from 36-48 months, 20% discount.

Units in service greater than 48 months, 10% discount.

Any help would be greatly appreciated!

Gary