Support Board
Date/Time: Sun, 02 Nov 2025 16:05:02 +0000
[Programming Help] - ignore zeros
View Count: 369
| [2024-03-31 16:32:44] |
| User411320 - Posts: 348 |
|
Hello, I'm trying to ignore zeros while using the MIN function on a single column =MIN(M3:1057) but the zeros are messing up another formula I'm working on. I've tried different variations and need help. thanks |
| [2024-03-31 16:38:59] |
| User411320 - Posts: 348 |
|
So I found the MINZ function, is this the proper function?
|
| [2024-03-31 16:45:44] |
| User411320 - Posts: 348 |
|
it gave me back 0.25 and the formula I'm using gave me back (#SYNTAX!) is it because the 0.25? the formula I'm using is (=M3-$T$3)/($U$3-$T$3) with U being the MAX function and M being x.
|
| [2024-03-31 21:43:38] |
| Sawtooth - Posts: 4285 |
|
the formula I'm using gave me back (#SYNTAX!)
Try this:=(M3-$T$3)/($U$3-$T$3) |
To post a message in this thread, you need to log in with your Sierra Chart account: