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 =… Read More »