Hi.
I'm trying to enter the VLOOKUP function for a discount on contract amount.
This table has two sheet. The first sheet is the "Contract Discount". The
second sheet is the "Lookup table". The discount total is in the cell C4.
which is located in sheet 1 "Contract Discount". The contract amount is in
cell A4 ($60,000) Sheet 1"Contract Discount". The discount is in sheet 2
which is the "Lookup table". Cell A2 should be: For Contracts between $40,000
and $80,000 there is a 3% discount. I try to use the VLOOKUP formula and the
IF formula and could not come up with the discount total in cell C4, sheet 1
"Contract Discount".
Any suggestions for a formula to do this?
Thanks.
Houa