Question

Q2: The employees of ABC Ltd are paid various allowances on basis of their designation.

Designation DA (RS) HRA (Rs)
Director 35000 27000
Manager 12000 18000
Supervisor 5000 3000

The records of an employee Mr Raj are to be entered in Row 10 and the employee’s designation is mentioned in Cell A10. Calculate:

a. His DA using a nested if statement

PLS ANSWER

Answer 1

Answer:

DA = "=IF(A10=A2,B2,IF(A10=A3,B3,IF(A10=A4,B4)))"

HRA = "=VLOOKUP(A10,A1:C4,3,false)"

Explanation:

Answer 2

Answer:

The Output is given in the excel sheet

Explanation:

• Type following formula in cell D3 to calculate DA (Dearness Allowance) as per given condition:
• =IF(OR(B3=”Accountant”,B3=”Manager”),C3*40%,C3*25%)
• OR, You can also apply or type another given formula to calculate DA
• =IF(B3=”Accountant”,C3*40%, IF(B3=”Manager”,C3*40%,C3*25%))
• After apply this formula you get the result in cell D3, now drag or copy this formula following range of cells D4:D11.