Support Board
Date/Time: Mon, 25 Nov 2024 05:13:39 +0000
[Programming Help] - ignore zeros
View Count: 216
| [2024-03-31 16:32:44] |
| User411320 - Posts: 289 |
|
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: 289 |
|
So I found the MINZ function, is this the proper function?
|
| [2024-03-31 16:45:44] |
| User411320 - Posts: 289 |
|
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: 4120 |
|
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: