HI
I am doing salary in exel and facing problem regarding PF calculation we have fixed our Basic 6500 for 30 days whose employee salary more than 6500 and calculating PF and put formula on same but when employee having amount less than 6500rs and present day 15 days then what formula we should put for it
Regards
Dilip

From India, Pune
Dear Dilip You can use IF and then functio of EXcel for this problem. Regards Alpna Prasad
From India, Allahabad
You can pur formula like : =if(or(basic salary<6500,days<30),0,basic salary*12%) here basic salary and days refers to cells containing salary and present days. Hope this will solve your problem.
From India
I can solve your problem but i cant understood your problem. pls describe it practically. or call +919898096367
From India, Surat
Dear Dilip, I can give you a comprehensive solution .Contact ,me on 09900456701 Regards, Vipin
From India, Bangalore
Mr. Dilip, Please check this attachment, i hope that this attachment is use full. U. Muninder
From India, Hyderabad
Attached Files (Download Requires Membership)
File Type: xls PF CALC.xls (17.5 KB, 744 views)

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.





Contact Us Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2024 CiteHR ®

All Copyright And Trademarks in Posts Held By Respective Owners.