I'm pretty much a noob at excel. What im trying to do is make a spreadsheet for supplies so all i do is enter the quantity and the price is worked out.

Item A - List Price £50 - Discount 85.5% - QTY 8 - Total.


When in excel it just takes £1 off that total. I have no clue how to get excel to take off a percentage of something. Can anyone help?