hello to every one . could any body give the formula for a situation where by just putting the number of days worked we get the basic salary pop in the salary cell. its very urgent as i am new to this company .
thanking in advance for the help , whoever would extend to me.

From India, Mangaluru
Hi Check this
From India, Bangalore

Attached Files
File Type: xls Salary sheet format.xls (355.0 KB, 53926 views)
File Type: xls Salary slip format.xls (19.5 KB, 17044 views)

i.ve checked the attachments , its quite helpful for me in the later stage , but currently i need the solution for the sheet which i have uploaded, where in u can find the " days" cell before "basic" cell , in the salary section , in the " days" cell when we put the days worked , it should give the basic salary , details of which are in Data sheet before "march" sheet. i hope u got wat i meant.
From India, Mangaluru

Attached Files
File Type: xls Employee Attendance and Salary Sheet.xls (984.5 KB, 24834 views)

mr arun attacheed plcheck ur sheet. i inserted one more column in b/w.
From India, Madras

Attached Files
File Type: xls amended.xls (644.5 KB, 8960 views)

Pl check attached file, hope it will serve yr purpose. rgds, Sharmamk
From India, Faridabad

Attached Files
File Type: xls Employee Attendance and Salary Sheet.xls (987.0 KB, 11213 views)

Pls find attached salary sheet,you can calculate ESI/PF/OT etc.. Best Regard Sajid Ansari-Delhi
From India, Delhi

Attached Files
File Type: xls Salary Calculation With OT ESI EPF ADV(1).xls (150.0 KB, 15907 views)

dear Pls see attached sample worksheet that may help you. V. Balaji
From India, Madras

Attached Files
File Type: xls sample payslip.xls (21.5 KB, 9379 views)

thanks a lot from all of you friends, i dun know if such a help would have been provided by my near n dear friends or no.who said Indians hate each other? this forum is a live evidence that we love each other. thank you all once again
From India, Mangaluru
friends i have another issue as well dun no whether to ask here or in some other topic, still i'll make n effort. issue is , i have done my LLB+MBA in HR n have joined a newly established medical transcription company , where in my role is yet to b known as i am the first HR of this company with 10 employees , n there is no training which i have undergone as an HR. plz help me or advise me as to wat can i do to help this co grow from legal and hr point of view . thanks in advance.
From India, Mangaluru
Dear Sr.
Plz help me for some confusion. How to calculate Professional tax ,as per day or as per salary. Eg.salary is 10000 and workinh days is 15 and as per professional tax slab we cut professional tax 150 or 120 ????
PLz sol my this quarry ...

From India, Ahmadabad

About Us Advertise Contact Us
Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2021 Cite.Co™