VLOOKUP
Here is part of my data for Contract Discounts sheet 1
Contract Amount
$15,000
$4,000
$60,500
$73,235
$8,025
$68,135
$12,000
$45,000
$82,002
$35,258
Here is the date for Lookup Table
If the contracts is under $10,000 there are no discount. Between $10,000 and
$20,000 there is a 1% discount, for $20,000-$40,000 there is a 2% dicounts,
between $ 40,000 and $80,000 there is a 3% discount and contract over $80,
000 there is a 5% discount.
Hopefull this will help you.
Toppers wrote:
Can you post your lookup table please.
Hi.
I'm trying to enter the VLOOKUP function for a discount on contract amount.
[quoted text clipped - 9 lines]
Thanks.
Houa
|