Payroll Question

[Shorya]

Create a payroll sheet in which basic pay of 20 employees is given.You have to calculate DA,HRA.CCA and gross pay of each employee using the formulas with the following conditions:
a) HRA is 50% of Basic pay and CCA is 15% of Basic pay.
b) The rates of DA for different levels of Basic pay are given in cells G to I as

G H I
1 Lower Limit Upper limit DA rate
2 0 6000 0.28
3 6001 12000 0.25
4 12001 & above 0.20

You have to ensure that DA amount paid to an employee with lower basic pay should not exceed the DA paid to an employee with higher basic pay.



This condition is making it hard.My term exams are banging on the door and this making me sick.Help me out.

 

[VoG]

We do not answer (in full) homework questions here.

Hint: with a salary in A1

=LOOKUP(A1,{0,6001,12001},{0.28,0.25,0.2})

 

[Akashwani]

Hi Shorya,

Welcome to MrExcel.

Homework eh? Well, you wont find anyone on here doing that for you
What you will get is some quality help though.

Take a look here...
http://www.youtube.com/watch?v=PDy3a7DK0_Q

If that doesn't help type payroll into the search box.

Good luck.

Ak