Support Board
Date/Time: Wed, 25 Feb 2026 07:54:56 +0000
Post From: formula
| [2026-02-24 16:35:25] |
| John - SC Support - Posts: 44784 |
|
We think you are stating that you only want the calculation to take place if the top number is negative and the bottom number is positive, and you are wondering how to do this. If this is the case, then you need to use the "AND()" function to add additional tests in your IF() statement. We think the following is what you are looking for, but we are not certain that we have your top and bottom correct, so you need to verify it: =IF(AND(ID3.SG38>=-10*ID3.SG37, ID3.SG38 > 0, ID3.SG37 < 0),ID3.SG38/-ID3.SG37,0) Refer to the following: Study/Chart Alerts And Scanning: OR and AND Functions For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |