Question

(1x5=5)
25.Answer the given questions after referring the following data:
A
B
C
D
E
S.NO.
NAME
BASIC PAY HRA
DA
1
TOTAL
2
1
AMAN
12000
3
2
BALJEET 15000
3
HARISH 14500
Write the functions/formula for the following:
a) To Calculate the HRA i.e. 12% of Basic pay.
b) To Calculate the DA i.e. 10% of Basic pay.
c) To get the TOTAL i.e. Basic pay+HRA+DA.
d) To find the Maximum and Minimum Basic pay.
e) What is the reference of shaded cell?​

Answer 1

Answer:

1263.1436

Explanation:

I hope it is correct ok