ExcelBanter - AREAS function

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - AREAS function (https://www.excelbanter.com/excel-discussion-misc-queries/164415-areas-function.html)

Dave F[_2_]

AREAS function

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

David Biddulph[_2_]

AREAS function

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

"Dave F" wrote in message
ups.com...
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

All times are GMT +1. The time now is 08:47 PM.