Rasheedcoorg
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?

From India, Bangalore
Rasheedcoorg
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?
i found the answer for this question :
here it is =IF(SUM(D3, E3) >= 15000, 1800, SUM(D3, E3)*12%)

From India, Bangalore
saumen12@gmail.com
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
From India, Kolkata
mayurc493@gmail.com
1

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.
From India, Thane
smitarosy@gmail.com
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.

From India, Patna
 excel assignment 001.jpg (548.1 KB, 200 views)

ganeshgpatil
2

From India, Uran
vairamani55@gmail.com
if basic wage is more then 6500 we should pay 5** something,is there any possible to pay less then that ceiling amount
From India, Chennai
=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
From India, Mumbai
Community Support and Knowledge-base on business, career and organisational prospects and issues - Register and Log In to CiteHR and post your query, download formats and be part of a fostered community of professionals.