View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
ewan7279
 
Posts: n/a
Default 'circular reference'

Circular references are caused when the result of a calculation is includedin
the calculation itself. An example would be if A5 contained the formula
=sum(A1:A4), but A2 contained the formula =A5.

Circular references are usually accidental errors, but there are some uses
in engineering calculations I believe.

"Rathika" wrote:

what are the uses in 'circular reference' and tell me in what situation I can
use that please?