Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
excell idiot
 
Posts: n/a
Default what is the correct syntax for an allowable circular reference?

I am trying to add the values of two cells and return an updated total to one
of the original two cells. Such as a weekly income update.
  #2   Report Post  
Jason Morin
 
Posts: n/a
Default

See J.E. McGimpsey's website on how to do this:

http://www.mcgimpsey.com/excel/accumulator.html

Scroll to the bottom of the page and look for:

"Worksheet Function Accumulator (using Circular
References)"

HTH
Jason
Atlanta, GA

-----Original Message-----
I am trying to add the values of two cells and return an

updated total to one
of the original two cells. Such as a weekly income

update.
.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
WHAT SYNTAX IS USED TO ROUND A 4-DIGIT NUMBER TO THE NEAREST THOUS KENITOSAN Excel Discussion (Misc queries) 4 February 19th 05 10:06 PM
Range.Select Using Variables - need syntax gradientS Excel Discussion (Misc queries) 3 February 16th 05 12:45 PM
MS Query - Alias syntax David P Excel Worksheet Functions 3 February 16th 05 09:29 AM
Vlookup Syntax Error YV New Users to Excel 9 December 23rd 04 05:28 PM
Previous Post - Correct Syntax Query Clarence Crow Excel Worksheet Functions 0 December 7th 04 05:35 AM


All times are GMT +1. The time now is 06:35 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"