Support Board
Date/Time: Sat, 28 Dec 2024 08:56:16 +0000
Post From: SPREADSHEET - MOSTRECENTNONZEROVALUE(Range)
| [2016-02-19 22:01:51] |
| Jeffrey - Posts: 2187 |
|
This is the documented functionality of the MOSTRECENTNONZEROVALUE formula function, as listed on the Spreadsheet Functions page: Returns the last non-zero value in the given Range. Empty cells are considered equivalent to zero. Returns a null value if all of the values in the Range are either null or zero.
Given the range G3:G10, and assuming the value at G10 is not 0 or empty, the function will return the value at G10. If all of the cells from G4 to G10 were empty, or had a value of 0, and G3 had some other value in it, then only in that case would the function return the value in G3. |