#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 168
Default 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.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Do I want to create a Circular references katencoresl Excel Worksheet Functions 4 January 25th 07 09:01 PM
Those Circular References... JeremyH1982 Excel Discussion (Misc queries) 4 May 22nd 06 10:51 PM
Circular references R.Hocking Excel Worksheet Functions 1 February 2nd 06 06:51 PM
Help :Circular References PPT Excel Worksheet Functions 1 January 29th 06 03:20 PM
Frequnecy Circular References barrie Excel Discussion (Misc queries) 3 April 15th 05 09:42 AM


All times are GMT +1. The time now is 10:25 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"