Salary Breakup - Xls Download - Salary Break Up

Hi Friends, Pls find the CTC break up. Hope this will help you all. regards Shiva
1st November 2012 From India, Mumbai

Attached Files (Download Requires Membership)

Doc2.docx (1.02 MB, 84 views)

Hi Ashok, Appreciate your reply but by deleting if salary above 15000 is not correct format. Instead u can use this formula in excel =IF(Gross<=15000,Gross*4.75%,0) for permanent format. Meenakshi
1st November 2012 From India, Chennai

Dear Meenakshi Your formula one problem no roundup value. so please you help full formula. THIS IS CORRECT FORMULA IN EXCEL =IF(GROSS>15000,0,ROUNDUP(GROSS*4.75%,0)) Vishnu
2nd November 2012 From India, Gurgaon

Dear employee’s Share =IF(GROSS>15000,0,ROUNDUP(GROSS*1.75%,0)) employer’s Share =IF(GROSS>15000,0,ROUNDUP(GROSS*4.75%,0))
2nd November 2012 From India, Gurgaon