VLOOKUP / HLOOKUP

[Aristo]

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.....

 

[Oaktree]

Welcome to the board.

If A1 has the original price,

=A1*LOOKUP(A1,{0,1;300,0.975;350,0.95})

will return the after-discount price.