I just want to know the Excel formula for the details given below. If the gross salary is greater than 6500, then PF should be 780, and if it is less than 6500, the PF amount should be 12% of the gross pay. I need the formula in Excel... please help me out.
Regards
From India, Madras
Acknowledge(1)
Amend(0)
2Regards
From India, Madras
Acknowledge(1)Amend(0)
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
From India, Delhi
Acknowledge(0)Amend(0)
From India, Delhi
Acknowledge(0)Amend(0)
Dear Hemanth, I tried ur formula but i didnt get the exact output. Pls find attachment and pls revert me regards Prabhakaran
From India, Madras
Acknowledge(0)Amend(0)
From India, Madras
Acknowledge(0)Amend(0)
Just make a small change in Hemanth's formula. Since you want the amount to be Rs. 780/- if the 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 the basic is above Rs. 6500/-), it will simply fetch 780/-.
Regards,
Raja C S N
Sr. Trainer / Consultant / Content Creator, Chennai.
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.
From India, Madras
Acknowledge(0)Amend(0)
Regards,
Raja C S N
Sr. Trainer / Consultant / Content Creator, Chennai.
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.
From India, Madras
Acknowledge(0)Amend(0)
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
From India, Delhi
Acknowledge(0)Amend(0)
From India, Delhi
Acknowledge(0)Amend(0)CiteHR is an AI-augmented HR knowledge and collaboration platform, enabling HR professionals to solve real-world challenges, validate decisions, and stay ahead through collective intelligence and machine-enhanced guidance. Join Our Platform.
Salary Sheet & PF PT Calculation & Challan.xls