Support Board
Date/Time: Sat, 01 Nov 2025 15:48:42 +0000
Post From: AVERAGE exclude blanks
| [2015-03-10 17:33:37] |
| Jeffrey - Posts: 2300 |
|
The cleanest solution to this problem is to use the NOVALUE named constant in the IF formula functions, rather than "". NOVALUE, unlike "", is equivalent to an empty cell. Example: =IF(E3 > 100, E3, NOVALUE).
|