Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
FUNCTION STABILITY
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
FUNCTION STABILITY
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 "romelsb" wrote in message ... | 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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
FUNCTION STABILITY
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. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
FUNCTION STABILITY
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. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
FUNCTION STABILITY
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. |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
FUNCTION STABILITY
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... "Ron Coderre" wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need some comments on my Utility_Move class module. | Excel Worksheet Functions | |||
Creating a Custom Excel Function to Calculate Gini Coefficients | Excel Worksheet Functions | |||
Date & Time | New Users to Excel | |||
Conversion | Excel Worksheet Functions | |||
HOW CAN I GET OFFICE 2003 EXCEL BASIC TO NEST FUNCTIONS LIKE EXCE. | Excel Worksheet Functions |