Seeking Help to prepare wage book for employees

%3CLINGO-SUB%20id%3D%22lingo-sub-1163025%22%20slang%3D%22en-US%22%3ESeeking%20Help%20to%20prepare%20wage%20book%20for%20employees%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1163025%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECan%20some%20help%20me%20with%20fixing%20up%20some%20formula%20to%20prepare%20wage%20book.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20to%20pay%20employees%20certain%20amount%20as%20net%20payment%20after%20all%20statutory%20deduction.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20the%20wage%20book%2C%20certain%20rates%20cannot%20be%20changed%20like%20Basic%2C%20HRA%2C%20VDA.%20However%2C%20Allowance%20can%20be%20paid%20more%20to%20arrive%20at%20the%20final%20desired%20net%20payment.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20attached%20a%20table%20in%20excel%20sheet.%20I%20will%20be%20grateful%20if%20someone%20can%20please%20help%20me.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERonald%20Pinto%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1163025%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1164374%22%20slang%3D%22en-US%22%3ERe%3A%20Seeking%20Help%20to%20prepare%20wage%20book%20for%20employees%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1164374%22%20slang%3D%22en-US%22%3EBecause%20this%20forum%20is%20dedicated%20to%20the%20Microsoft%20Access%20Relational%20Database%20Development%20tool%2C%20you%20might%20have%20better%20response%20from%20reposting%20this%20question%20to%20a%20forum%20dedicated%20to%20the%20Microsoft%20Excel%20tool.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1175709%22%20slang%3D%22en-US%22%3ERe%3A%20Seeking%20Help%20to%20prepare%20wage%20book%20for%20employees%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1175709%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F46682%22%20target%3D%22_blank%22%3E%40George%20Hepworth%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eyes%2C%20as%20advised%20I%20had%20reposted%20and%20received%20a%20very%20good%20help%20from%20the%20members%20specially%20Mr.Sergei%20Baklan%2C%20Mr.%20Riny_van_Eekelen%20and%20Mr.%20Abiola1%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%2C%3C%2FP%3E%3CP%3ERonald%20Pinto%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Contributor

Hello, 

 

Can some help me with fixing up some formula to prepare wage book.

 

I have to pay employees certain amount as net payment after all statutory deduction.

 

In the wage book, certain rates cannot be changed like Basic, HRA, VDA. However, Allowance can be paid more to arrive at the final desired net payment.

 

I have attached a table in excel sheet. I will be grateful if someone can please help me.

 

Ronald Pinto 

2 Replies
Because this forum is dedicated to the Microsoft Access Relational Database Development tool, you might have better response from reposting this question to a forum dedicated to the Microsoft Excel tool.
Highlighted

@George Hepworth 

 

yes, as advised I had reposted and received a very good help from the members specially Mr.Sergei Baklan, Mr. Riny_van_Eekelen and Mr. Abiola1 

 

Thank you,

Ronald Pinto