BET: Microsoft Excel Array Formulas - Problems with Array Formulas

Microsoft Excel > Array Formulas > Problems with Array Formulas

	A small number of the worksheet functions can be described as "volatile" functions.
	This means that these functions constantly update when any changes are made to the worksheet.
	If any of these functions are included in your array formulas and they are used with references to large cell ranges then the worksheet will not be very efficient.
	The following is a list of volatile functions.

AREAS	The number of areas in a cell range or reference.
CELL	The number or text string indicating information about a cell.
COLUMN	The column number of the cell reference.
COLUMNS	The number of columns in a cell range or reference.
INDIRECT	The text string of the contents of a given cell reference.
INFO	The text string returning useful information about the environment.
NOW	The date serial number of the current system date and time.
OFFSET	The cell value which is an offset from a given cell reference.
RAND	The random number between 0 and 1.
ROW	The row number of the cell reference.
ROWS	The number of rows in a cell range or reference.
TODAY	The serial number representing today's date.