Volatile Functions

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.

CELLThe number or text string indicating information about a cell.
INDIRECTThe text string of the contents of a given cell reference.
INFOThe text string returning useful information about the environment.
NOWThe date serial number of the current system date and time.
OFFSETThe cell value which is an offset from a given cell reference.
RANDThe random number between 0 and 1.
TODAYThe serial number representing today's date.

double check that ROWS, COLUMNS and AREAS are volatile in Excel 2013 ?


SUMIF

SUMIF(A1:A4,">0",B1) is volatile
but
SUMIF(A1:A4,">0",B1:B4") is not volatile


INDEX

This is not volatile despite some documentation from Microsoft that says it is ?


ROWS

This is not volatile despite some documentation from Microsoft that says it is ?


COLUMNS

This is not volatile despite some documentation from Microsoft that says it is ?


AREAS

This is not volatile despite some documentation from Microsoft that says it is ?



© 2019 Better Solutions Limited. All Rights Reserved. © 2019 Better Solutions Limited TopPrevNext