Hello everybody 
?
I am a bit new to excel, I am trying to calculate a financial spreadsheet for a business, I am having trouble using VLOOKUP to calculate a scenario were the owner gets a 2.5% discount if cost of materials is between £300 and £350, and gets 5% discount if cost of materials is greater than £350.
I would really appreciate it if anyone could help me.....
? I am a bit new to excel, I am trying to calculate a financial spreadsheet for a business, I am having trouble using VLOOKUP to calculate a scenario were the owner gets a 2.5% discount if cost of materials is between £300 and £350, and gets 5% discount if cost of materials is greater than £350.
I would really appreciate it if anyone could help me.....
