Thank you.

tim m wrote:
I don't think you want to use a Vlookup for this as it is going to look for
an exact match rather than a range of values. You could try this formula
below. Format a column as % and enter this formula. (In the formula A2 is
the start of your contract amounts.)

=IF(A280000,0.05,IF(A239999,0.03, IF(A219999,0.02,IF(A29999,0.01,0))))

Here is part of my data for Contract Discounts sheet 1
Contract Amount
[quoted text clipped - 24 lines]
Thanks.
Houa

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200606/1