FUNCTION STABILITY

R

romelsb

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.
 
N

Niek Otten

Maybe you can re-formulate your question? I have no idea what you mean. I waited for others to answer your question but it looks
as if it's not too clear.

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| 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.
 
R

Ron Coderre

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
 
R

romelsb

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

Ron Coderre

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
 
R

romelsb

Thanks Ron for the reply...My reason..I have a spreadsheet before where I
used this row() function within a formula IN THESE CELLS and it was logically
linked with other formulas on other Worksheets....then some dummy guy insert
cells randomly on top of these and upon save/close the file - I lost the
logic on the whole workbook...its a financial worksheet...anyway, I hope
there will be some way later to control this simple situation....I would like
to know other functions if it behaves the same....thanks a lot...
 
Top