DOES YOU CIRCULAR REF. TOOLBARS BLINK !!!<<

Of course it does! In fact, I got the circ ref warning as soon as I put the
formula into B21.....But nothing to do with the ROW functions.

A21 refers to B21
and B21 refers to A21

That's a typical circular reference.

Um....Did you have a reason for asking me to do that?

***********
Regards,
Ron

XL2002, WinXP


"romelsb" wrote:

try this :
from CELL A21 = ROW()+B21
from CELL B21 = ROW()+A21
CUT B21 then PASTE to B23
DOES YOU CIRCULAR REF. TOOLBARS BLINK !!!


"Ron Coderre" wrote:

Do you mean these functions which refer to their container cells?

A1: =COLUMN(A1)....returns 1
A1: =COLUMNS(A1)....returns 1
A1: =ROW(A1)....returns 1
A1: =ROWS(A1)....returns 1
A1: =CELL("address",A1)
A1: =OFFSET(A1,1,0)....as long as it doesn't resolve to A1...returns the
ref'd cell value

That's all I can think of right now.

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"romelsb" wrote:

Can anybody tell me which of the functions are undetectable by a circular
formulation - considering calculation mode is automatic... Really i need
this for awareness and avoidance of erroneous results.