Question

Milan Fashions maintain their employee salary details in a spreadsheet as shown below. A
sample data of 7 employees is shown below. Write formulas for the operations () to (IV) based
on the spreadsheet given below along with the relevant cell address:
NET
20000
20000
60000
45000
700
A
Jyoti
25000
30000
DOOO
TEXT
10 No of mp
(0) To calculate the DA as 25 % of BASIC+HRA for each employee and display in column D.
(ii) To calculate the NETSALARY as BASICHRA DA PF for each employee and display in
column F.
(iii) To find the maximum NETSALARY and display in cell F9.
(iv) To count the number of employees and display in cell B10.​

Answer 1

Answer:

to find the maximum netsalary and display in cell B10