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??? :)


--
bluenoser1946
------------------------------------------------------------------------
bluenoser1946's Profile: http://www.excelforum.com/member.php...o&userid=26006
View this thread: http://www.excelforum.com/showthread...hreadid=468685

=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

You cannot put that formula in either Q25 or T18.

--
HTH

Bob Phillips

"bluenoser1946"
wrote in message
news:bluenoser1946.1vl02e_1127091930.1306@excelfor um-nospam.com...

=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