Salary Calculation

[dhanrajg]

Hello,

I want a excel formula to calculate monthly salary of my staff
I already maintain a excel of staff attendance.
like this

	STAFF A	STAFF B	STAFF C	STAFF D	STAFF E
1-Sep	L	P	P	P	A
2-Sep	SUNDAY	SUNDAY	SUNDAY	SUNDAY	SUNDAY
3-Sep	L	P	P	A	P
4-Sep	P	P	P	A	A
5-Sep	A	P	P	P	P
6-Sep	P	P	P	P	P
7-Sep	P	P	A	L	P
8-Sep	P	P	P	P	A
9-Sep	SUNDAY	SUNDAY	SUNDAY	SUNDAY	SUNDAY
30-Sep	SUNDAY	SUNDAY	SUNDAY	SUNDAY	SUNDAY
	WANT FORMULA HERE TO CALCULATE SALARY OF STAFF
	WITH BASE SALARY INTO CONSIDERATION AND ATTENDANCE CALCULATION

<colgroup><col span="3"><col><col span="4"></colgroup><tbody>
</tbody>

 

[etaf]

how is the salary calculated?
L = leave ?
P = ?
A = absent ?
so whats the base salary and do we simply work out the day rate and count the "P"
or different rates for Different days ?

 

[paldob]

Couldn't you just use a countif and multiply the value by their daily rate? This is assuming that the information etaf detailed above - L = Leave / P = Paid?. So you would count how many L and P's they have then multiply by daily rate.