AREAS function

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
 
D

David Biddulph

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