+ Reply to Thread
Results 1 to 6 of 6

Problem in Calculation

  1. #1
    Forum Contributor
    Join Date
    07-15-2015
    Location
    Kolkata
    MS-Off Ver
    2010 & 2013
    Posts
    290

    Problem in Calculation

    Hi,

    Please help me to solve the formula on 3 columns (column J, K, L). i tried to solve but i can't.

    Column J = If Monthly Gross is < 40000 then the formula is applicable
    Column K = If Monthly Gross is < 40000 then the formula is applicable
    Column L = If Monthly Gross is >= 40000 then the formula is applicable
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    06-13-2018
    Location
    india
    MS-Off Ver
    2010;2007
    Posts
    54

    Re: Problem in Calculation

    Hello Sanjibghosh,

    monthly gross is available in column N, isn't it?

  3. #3
    Forum Contributor
    Join Date
    07-15-2015
    Location
    Kolkata
    MS-Off Ver
    2010 & 2013
    Posts
    290

    Re: Problem in Calculation

    Hi kuschem,

    Yes, monthly gross is available in column N.

  4. #4
    Registered User
    Join Date
    06-13-2018
    Location
    india
    MS-Off Ver
    2010;2007
    Posts
    54

    Re: Problem in Calculation

    YOUR SHEET HAVE CIRCULAR REFERENCES
    SUCH THAT IN MONTHLY GROSS COLUMN N formula is =SUM(F4:M4)

  5. #5
    Registered User
    Join Date
    06-13-2018
    Location
    india
    MS-Off Ver
    2010;2007
    Posts
    54

    Re: Problem in Calculation

    you can enable circular references by
    select File---> options----> formula-----> check ENABLE ITERATIVE calculation

    Hope this helps
    Regards
    Hemesh

    If this helps click Star button to Add Reputation
    Attached Files Attached Files
    Last edited by kuschem; 06-13-2018 at 03:56 AM.

  6. #6
    Forum Expert
    Join Date
    05-05-2015
    Location
    Waterlooville,England
    MS-Off Ver
    Office 2010
    Posts
    16,518

    Re: Problem in Calculation

    Is your logiccorrect:

    in the File posted in #5 you get from a basic of 14000 to gross of over 51000 which is in a large part due to "iterative nature" of the gross calculation (SUM(Ff$:M4). the latter includes the allowance in L4.

    Without L4 the Gross would be 29,200 and surely the L4 calculation should be based on this (as should those in J and K) ????
    Last edited by JohnTopley; 06-13-2018 at 06:07 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 1
    Last Post: 01-15-2013, 08:51 AM
  2. [SOLVED] Calculation Problem
    By Daywalker in forum Excel General
    Replies: 9
    Last Post: 09-25-2009, 02:46 AM
  3. Calculation Problem
    By penfold in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-09-2008, 01:39 PM
  4. [SOLVED] Calculation problem - please help
    By Neil Hindry in forum Excel General
    Replies: 2
    Last Post: 07-10-2006, 09:39 AM
  5. Calculation Problem
    By spiney in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 02-10-2006, 01:29 PM
  6. [SOLVED] calculation problem
    By les in forum Excel General
    Replies: 1
    Last Post: 11-24-2005, 07:40 AM
  7. [SOLVED] Calculation problem
    By Ajtb in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-25-2005, 05:06 AM
  8. [SOLVED] Calculation problem
    By Ajtb in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-24-2005, 05:06 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