Home >> Support Board

Support Board

Date/Time: Tue, 07 May 2024 16:04:02 +0000

How to Post a Message for Support

[Programming Help] - ignore zeros

View Count: 83

[2024-03-31 16:32:44] #1 [Go To First Post]
User411320 - Posts: 265
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] #2 [Go To First Post]
User411320 - Posts: 265
So I found the MINZ function, is this the proper function?

[2024-03-31 16:45:44] #3 [Go To First Post]
User411320 - Posts: 265
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] #4 [Go To First Post]
Sawtooth - Posts: 3993
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: