AREAS function

  • Thread starter Thread starter Dave F
  • Start date Start date
D

Dave F

Any idea why the function AREAS does not create circular reference
errors? =AREAS(A1) entered in A1 returns 1, not a circular reference
error.

No, iteration is not checked in the options, so that would not explain
this.

Thanks,

Dave
 
It's not a circular reference because the result is not dependent on the
value in the cell.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Circular reference toolbar not working 3
calculation-iterations 10
Iteration frustration 2
user defined functions format 3
Saving Excel Pro 2003 iteration results 9
Mode Function or MODE Function -- Can't get it to work!! 4
Those Circular References... 4
Circular Calculation with TREND Function? 7

Back
Top