Softskills Trainer
Hrm & Legal Advisory
+2 Others

Dear Seniors,
I jus wanna know the excel formula for the the details given below.
If gross salary is greater than 6500 then pf should be 780, and if lesser than 6500 the pf amount should be 12% gross pay.
I need the formula in excel... pls help me out.

Cite.Co is a repository of information created by your industry peers and experienced seniors made possible with help from our prime sponsors like:

TALENTEDGE Who provide a platform for "interactive anywhere learning". Courses from top reputed institutes like IIM, XLRI, MICA. View Courses

FACTOHR - Provides Customised Payroll, GPS Enabled Attendance, Travel, Performance Management, HRMS that can help streamline your organisation. Explore Features

Register Here and help by adding your inputs. Contributions From Other Members Follow Below...
Dear Please use this can be resloved your query - =IF(G4<=6500,G4*12%,0) G4 stand for Cell where is the actual calcualated Basic can be
Dear Hemanth, I tried ur formula but i didnt get the exact output. Pls find attachment and pls revert me regards Prabhakaran

Attached Files
Membership is required for download. Create An Account First
File Type: xls New Microsoft Excel Worksheet.xls (15.5 KB, 633 views)

Just make a small change in Hemanth's formula. Since you want the amount to be Rs.780/- if basic is above 6500/-, replace the zero in the formula with 780/- and check.
The IF STATEMENT will check the basic amount - if it is less than or equal to 6500/- then it will produce 12% of it in the cell where the formula is keyed in. Otherwise, (i.e. when basic is above Rs.6500/-) it will simply fetch 780/-
Raja C S N
Sr Trainer / Consultant / Content Creator,
BTW, if you are in Chennai, you can get my personal services on all your excel related queries at a reasonable cost, if you are interested.

Need to be amend =IF(N5<=6500,N5*12%,0) Wrong On Actual Basic Not on Gross Formula in same sheet can be =IF(F5<=6500,F5*12%,0) and check it again
PFA the file as per requirement. Feel free to reach me in case of query.

Attached Files
Membership is required for download. Create An Account First
File Type: xls Book1.xls (18.5 KB, 94 views)

Add Reply Start A New Discussion

About Us Advertise Contact Us
Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2019 Cite.Co™