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
6I 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
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
From India
I can solve your problem but i cant understood your problem. pls describe it practically. or call +919898096367
From India, Surat
From India, Surat
Dear Dilip, I can give you a comprehensive solution .Contact ,me on 09900456701 Regards, Vipin
From India, Bangalore
From India, Bangalore
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.
CB- Salary Structure Formula.xls