Support Board
Date/Time: Sun, 15 Jun 2025 16:42:20 +0000
Post From: Which one of these formulas is more CPU friendly in Spreadsheet Studies?
| [2025-06-03 17:38:49] |
| C_Money - Posts: 83 |
|
The MAX() function is going to be more efficient overall, as there is less looping to determine the particular value. Although we can not say how much more efficient one is over another.
But, these two functions (MAX() and MOSTRECENTNONZEROVALUE()) perform two different things. You will not get the same result from those two functions. Got it, thanks. Yeah the only 2 numbers the cells they are referencing would only ever return either a 3 or a 0 so that's why I was wondering if MAX would have been a better fit. Is there a better function than MAX that would be more efficient in this case? |