Results 1 to 5 of 5
  1. #1
    New Lounger
    Join Date
    Aug 2002
    Location
    Warrenton, Virginia, USA
    Posts
    7
    Thanks
    0
    Thanked 0 Times in 0 Posts

    circular calculations (office 97)

    I need to understand how to update a cell with new information based on a calculation and the last piece of old information, without running into a circular caluation error. For example in payroll data: A=hours worked, B=wages based on A, C=Year To Date (YTD) sum, D=new YTD sum (C+[img]/forums/images/smilies/cool.gif[/img] - this always gives me an error because I am trying to update the cell containing C with new data from D. Any help will be appreciated.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: circular calculations (office 97)

    Do A, B, C and D refer to single cells or to columns?

    If you overwrite hours worked each time:
    <UL><LI>Select and copy the wages cell.
    <LI>Select the YTD cell.
    <LI>Point to Edit/Paste Special...
    <LI>Select the Values and Add radio buttons and click OK.[/list]It might be better to keep a list of worked hours in a column (each new entry goes into cell below the previous one), have wages in the column next to that, and a running YTD sum in the next column (add wages in the current row to YTD from the previous row).

  3. #3
    New Lounger
    Join Date
    Aug 2002
    Location
    Warrenton, Virginia, USA
    Posts
    7
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: circular calculations (office 97)

    Thanks for the fast reply. The ABCD refer to single cells. I have used additional cells in the past, but I don't want that data to appear on the printout. I'll try your suggested approach - not sure I understand it but will see where it leads me.
    Thanks

  4. #4
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: circular calculations (office 97)

    If you don't want some data to print, you can always hide the column that needs not to be printed.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  5. #5
    New Lounger
    Join Date
    Aug 2002
    Location
    Warrenton, Virginia, USA
    Posts
    7
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: circular calculations (office 97)

    I tried what you suggested but for some reason I get a multiplication in the YTD cell instead of an add, even though I selected paste special add values. Tried different approaches but always get the same multiple value or a circular error notice.
    Anything else you can suggest?
    Thanks

Posting Permissions

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