### Dinesh Divekar

Business Mentor, Consultant And Trainer

### Umakanthan53

Labour Law & Hr Consultant

Seasoned Ir Professional

KK

### KK!HR

Management Consultancy

### Saswatabanerjee

Partner - Risk Management

### Drsivaglobalhr

Doctor Siva Global Hr

### Nanu1953

Ceo-usd Hr Solutions

AU

### Aussiejohn

Workplace Assessment And Training

Sr. Hr Manager

Hr & Ir

NV

### Nagarkar Vinayak L

Hr And Employee Relations Consultant

Labour Law & Ir.

NA

### Nathrao

Insolvency N Gst Professional

### Kumaracme

Hr Manager, A Leading Manufacturing Company

BA

### Srivastavacmlal

Master Consultant

### NK SUNDARAM

International Corporate Trainer / Hr (od) Consultant

Joint Manager

Labour Laws & Ir

### Bijay_majumdar

Freelancer In Hr &indirect Taxes For Services Indusrty.

### Jeevarathnam

Sr Manager Hr & Compliances

GL

### Glidor

Hr Consultant

Asso.prof.(commerce & Management)

### Suresh2511

Labour Consultant

SU

Sr. Executive-hr

Hr Consultancy

DS

RS

### Ravikant.shah

Human Resource Management

PR

Office Manager

RK

SJ

Hr Manager

L8

General Manager

AH

Assistant Hr

AN

Sr Gm Hr

SA

Depty Hr Manager

@R

Group Hr

SK

### Sarah K

Hr Manager

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, 182 views)

ganeshgpatil
2

salary slip headwise detail rules
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 You Are Knowledgeable About Any Fact, Resource or Experience Related to This Topic and Want to Be Part of our support system - Please Register and Log In to CiteHR.