Hi Friends, Pls find the CTC break up. Hope this will help you all. regards Shiva
From India, Mumbai
From India, Mumbai
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
From India, Chennai
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
From India, Gurgaon
From India, Gurgaon
Community Support and Knowledge-base on business, career and organisational prospects and issues - Register and Log In to CiteHR and post your query, download formats and be part of a fostered community of professionals.
Typical salary breakup.jpg
Salary breakup format.xls