Results 1 to 3 of 3

Circular Formula & Reverse calculation

Threaded View

  1. #1
    Registered User
    Join Date
    05-06-2011
    Location
    Chennai
    MS-Off Ver
    Excel 2007
    Posts
    1

    Circular Formula & Reverse calculation

    Hi,

    I am working on the CTC structure changes for India. While computing for the restriction due to Minimum Wages, I have the below challenge.

    Sample case:
    Total CTC agreed is Rs. 75000/- out of which Statutory bonus will be Rs 3500/-. Remaining amount under CTC is Rs. 71500/-. Since CTC will comprise the Employer contribution in PF & ESI apart from Basic, reverse computation of Basic is mandated. Employer contribution in PF will be 12% & in ESI will be 4.75%. Need to arrive the basic so that the total CTC incl bonus is 75000.

    It would be better if excel formulae is used for this calculation instead of Macro.

    Please help.

    Regards

    S Rajesh
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Reverse calculation
    By puiuluipui in forum Excel Formulas & Functions
    Replies: 14
    Last Post: 06-19-2014, 09:00 AM
  2. Progressive tax calculation formula, in reverse
    By harro9 in forum Excel General
    Replies: 4
    Last Post: 12-01-2012, 03:34 AM
  3. Using circular calculation selectively
    By PRW71 in forum Excel General
    Replies: 0
    Last Post: 03-08-2010, 09:13 AM
  4. Reverse Calculation
    By Stephan1 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-13-2008, 09:48 AM
  5. Circular Calculation
    By Taylor_1978 in forum Excel General
    Replies: 4
    Last Post: 10-04-2007, 08:29 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1