Salary Sheet Problems

[shujon]

I have my CSE-101 Exam ahead and all I know can do in MS Excel is simple summations and deductions. I would be really grateful if someone helps me out with my following problem.

Consider the following payroll information of a company and write the formula asked.

House Allowance:
40% of Basic salary.

Medical Allowance:
1000 Tk. Whose Basic salary is more than 20000 Tk.
800 Tk. Whose Basic salary is more then or equal to 15000 Tk.
600 Tk. Whose Basic salary is less than 15000 Tk.

	A	B	C	D	E	F	G
1	Employee’s ID	Class	Basic Salary	Medical Allowance	House Allowance	Overtime (Hour)	Total Salary
2	2001-1-23-345	A	50000			10
3	2000-3-56-756	B	25000			15
4	2002-7-56-243	B	25000			25
5	2003-1-10-032	A	50000			10
6	2004-4-67-465	A	50000			21
7	2006-4-67-342	C	20000			24

<tbody>
</tbody>

1. Write a formula to calculate the Medical Allowance for every employee.
2. Write a formula to calculate the House Allowance for every employee.
3. Write formula to find total salary of the employees above (500tk/Hour is given for overtime).
4. Write a formula to calculate the number of employees of A, B and C class employees and show it in a chart.
5. Write a formula to find the sum of Medical allowance of class C employees.
6. Write a formula to find the average House Allowance of class B employees

 

[Toonies]

Medical allowance

=(C2)*0.4

Housing Alowance

=IF(C2<15000,600,IF(C2=15000,800,IF(C2<20000,800,IF(C2>20000,1000,800))))

I'm sure that you are supposed to do homework yourself

 

[shujon]

Thanks I do my own home work but the problem is I find excel & database related works difficult. But I am trying.

Thanks again
Shujon