Required Formula - Xls Download

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

Dear Dilip
You can use IF and then functio of EXcel for this problem.
Regards
Alpna Prasad

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.

I can solve your problem but i cant understood your problem. pls describe it practically. or call +919898096367

Dear Dilip,
I can give you a comprehensive solution .Contact ,me on 09900456701
Regards,
Vipin

Mr. Dilip,
Please check this attachment, i hope that this attachment is use full.
U. Muninder