Need Formula/procedure For EPF / PF Calculation Excel File

If the amount is equal to 15000 then we give the mentioned formula = sum( Basic+ DA)*12%. ( in salary statement or payroll statement- excel )
what is the formula if Basic+ DA less or greater than 15000?
can anybody answer me please?

Hi,
If the amount is equal to 15000 then we give the mentioned formula = sum( Basic+ DA)*12%. ( in salary statement or payroll statement- excel )
what is the formula if Basic+ DA less or greater than 15000?
can anybody answer me please?
i found the answer for this question :
here it is =IF(SUM(D3, E3) >= 15000, 1800, SUM(D3, E3)*12%)

Dear Sir,
One of my friend is working as Security Guard. He is paid on daily basis. The security agent deduct PF from his salary. Please tell me how he will calculate PF against his salary

Hi,
i worke in Pvt.company last 5.5 year my PF was cut in my salary Rs.865
so how much Rupees i got.

sir,
I have to explain this excel assignment to the students. plz help me. i have send the scanned assignment so that u can know excaltly what i need is formula for DA, TA,HRA, Spl. Allow, EPF, HRD, Tax.

salary slip headwise detail rules

if basic wage is more then 6500 we should pay 5** something,is there any possible to pay less then that ceiling amount

=IF(Pf Gross Salary)>15000,15001,(PF gross Salary)*12%
pf gross salary means basic, ca, cca, special allowance.
this is pf formula for 1800 max cap formula.
it is very help full to all