Ms excel Practical Question with solution; How to create commission amount of Products?

Question:- Calculate commission for following data in Sheet 1. (5)

S.no.	Product	Cost Price	Selling Price	Commission%	Commission Amt.
1	Makita Hand Drill 3420	$3000.00	$4200.00
2	Philips Steam Iron PS243	$300.00	$385.00
3	Soni Camcord $C331	$1200.00	$1800.00

a) Commission is 7% for all (Selling Price-Cost Price) is more than $500, otherwise it is 4%.

b) Commission Amount is calculated as Commission Percentage of Cost Price.

Solution:-

Formula:-

Commission % (E2):-    =IF((D2-C2)>500,7%,4%)

Commission Amount (F2):-    =E2*C2