I know how to work out percentages, but what I want to do is create a 'table' of prices, from the inputted values, I want the spreadsheet to automatucally work out the 'actual value' after discounting the percentage I am allowing my customers.

I have entered all the values, I just need to know the math hidden in the cells, any ideas please ?

 

Forgot to mention ...

The X and Y axis are Height and Width and the table needs to contain the data for items that fit within that height/width range ..... Just to make it a little more difficult.

 

Rather then me trying to explain it, Google excel % formulas