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.

25th September 2012 From India, Madras

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
25th September 2012 From India, Delhi
Hemant Kumar

“ Changing the Face “ can change nothing...But “ Facing the Change “ can change everything !!
“If u can't be a pencil to write anyone's happiness, try atleast to be a nice rubber to erase everyone's sorrows…”
Dear Hemanth, I tried ur formula but i didnt get the exact output. Pls find attachment and pls revert me regards Prabhakaran
25th September 2012 From India, Madras
Attached Files
Registration required. Create all access/no charge Cite.Co account first.
File Type: xls New Microsoft Excel Worksheet.xls (15.5 KB, 541 views)
Hi,
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/-
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.

26th October 2012 From India, Madras
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
13th May 2013 From India, Delhi
Hemant Kumar

“ Changing the Face “ can change nothing...But “ Facing the Change “ can change everything !!
“If u can't be a pencil to write anyone's happiness, try atleast to be a nice rubber to erase everyone's sorrows…”
PFA the file as per requirement. Feel free to reach me in case of query.
20th March 2017 From India, Indore
Attached Files
Registration required. Create all access/no charge Cite.Co account first.
File Type: xls Book1.xls (18.5 KB, 38 views)
Rush B
 

Discuss problems openly with your peers around the world without getting into company specifics. Access to years of such problem discussion data and business material is at your finger tips. All resources created by our members are available to everyone at no cost.


Disclaimer: This network and the advice provided in good faith by our members only facilitates as a direction. The advice should be validated by proper consultation with a certified professional. The network or the members providing advice cannot be held liable for any consequences, under any circumstances.


About Us - Advertise - Contact Us - RSS   On Google+  
Privacy Policy | Disclaimer | Terms Of Service
Facebook Page | Follow Us On Twitter | Linkedin Network





X