circular references
 

For me your formula returned a circular reference whether or not you use an
array. If you don;t mind me asking, what is the point of this formula? You
are typing the formula in the cell so it definitely won't be blank.

Adam Bush

"Dave F" wrote:

=ISBLANK(B1) entered in B1 and committed as an array formula does not show up
as a circular reference. =ISBLANK(B1) entered in B1 and entered normally
does show up as a circular reference.

??
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.