+ Reply to Thread
Results 1 to 3 of 3

Circular Reference???

  1. #1
    Registered User
    Join Date
    08-07-2005
    Posts
    6

    Circular Reference???

    OK, I created an Energy Balace Chart to help me eat healthier and track my daily progress. Everything works as designed except for my Grand Total column which I want to calculate once every 7 days. This is a sample of the formula I used
    =IF(Q25=),"".(T18+Q25))

    When I open the spread sheet I get this message...Cannot calculate a formula.Cell reference in the formula refer to the formula's result creating a circular reference.

    Can someone please help???

  2. #2
    Registered User
    Join Date
    08-07-2005
    Posts
    6

    oops

    =if(q25=0,"",(t18+q25))

  3. #3
    Bob Phillips
    Guest

    Re: Circular Reference???

    You cannot put that formula in either Q25 or T18.

    --
    HTH

    Bob Phillips

    "bluenoser1946" <[email protected]>
    wrote in message
    news:[email protected]...
    >
    > =if(q25=0,"",(t18+q25))
    >
    >
    > --
    > bluenoser1946
    > ------------------------------------------------------------------------
    > bluenoser1946's Profile:

    http://www.excelforum.com/member.php...o&userid=26006
    > View this thread: http://www.excelforum.com/showthread...hreadid=468685
    >




+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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