Support Board
Date/Time: Thu, 01 May 2025 00:50:49 +0000
LN function
View Count: 139
| [2025-03-17 18:18:09] |
| User411320 - Posts: 319 |
|
Hello, I'm applying the LN to standard RSI and getting sum #NUM! values, I reviewed the documentation so is there a way to ignore the zeros or use the last number before the zero? |
 Screenshot 2025-03-17 141424.png / V - Attached On 2025-03-17 18:17:55 UTC - Size: 11.28 KB - 20 views Screenshot 2025-03-17 141444.png / V - Attached On 2025-03-17 18:18:02 UTC - Size: 7.74 KB - 19 views |
| [2025-03-17 20:15:13] |
| John - SC Support - Posts: 39580 |
|
Use and "IF()" function to filter out the zero values that feed into the LN() function. You need to decide what you want to have set in the field when you do have a 0. For instance, here is an example entry where the data you want to take the natural log of is in column K and you want a zero to show as a zero in the results: =IF(K3 <> 0, LN(K3), 0) For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2025-03-18 18:49:41] |
| User411320 - Posts: 319 |
|
THANK YOU
|
To post a message in this thread, you need to log in with your Sierra Chart account: