• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

formula for annual all staff salaries individual employee wise monthly salary & TDS

GVN KUMAR

Member
Excel Genus,
I have prepared my client office staff annual salary and Income Tax deduction sheets 2 + 1 input sheets
my self maximum prepared annual salary details and pan numbers Total PAN deductions.
my requirements → each employee (1) monthly Gross salary and (2) I T details required formula
Could you help for staff self-verification purpose and acceptance taking purpose prepared sheet sir
any suggestion in my written formula in any sheet
attached xls file sir
( I have learned from this blog and single time paid for the advanced excel course and blog articles )
 

Attachments

  • CHANDOO Q4.xlsx
    83.4 KB · Views: 12
we have written formula for this problem

our problem our level solution
 

Attachments

  • meo s konda q4.xlsx
    61.6 KB · Views: 12
Back
Top