👤

(b) In an Excel work sheet if cell Al contains the basic salary of a person as
Rs. 12000 ., cell Bl contains Car allowance as 1500 Rs. and cell Cl contains House rent allowance as 5000 Rs. Write a formula to calculate the following .
(i) Gross salary = Basic salary + Car allowance + House Rent allowance
(ii) Net salary = Gross salary — 2% Basic salary.