VALUE.DETECTCHANGE
Checks specified cells or cell-ranges and returns TRUE if at least one value changes between steps.
Syntax
=VALUE.DETECTCHANGE(Range1...RangeN)
Arguments
| Name | Type | Description |
|---|---|---|
| Range1...RangeN | Ranges or Cells | Cells and cell-ranges to check for value changes. |
Return
| Type | Description |
|---|---|
| Boolean | TRUE, if at least one value has changed. |
Examples
| A | |
|---|---|
| 1 | =A1+1 |
| Formula | Result | Comment |
|---|---|---|
| TRUE | Always returns true since cell A1 increases on every step |