Create a work sheet containing pricing information of a company which deals in sales of computers & computer peripherals. You are required to calculate discount, sales price (MRP- Discount) and profit margin(MRP-sales price)

Firstly Find 10% Discount = cell_name * 10%

i.e E8 * 10% then Press Enter and Drag Till last value

After finding 10% Discount Find Sales Price Formula for Sales price is MRP – Discount = Sales_Price

Or You can Directly Find Profit Margin by using Formula

= (MRP – Discount) – Manufacturing_Price

i.e = (E8-F8) – D8

where E8 is MRP Price , F8 is Discount Price and D8 is Manufacturing_Price