Support Board
Date/Time: Mon, 25 Nov 2024 19:42:18 +0000
Post From: SpreadSheet Equation Stopped Working
| [2024-02-12 20:41:55] |
| John - SC Support - Posts: 36277 |
|
You definitely should not be getting a "#DIV/0" error, as there is no division occurring in your formula. Make sure the formula is still the same as you entered it and it did not get changed somehow by accident. It sounds like there is a slash (/) in there somewhere now that is causing an issue. Also, just for slightly faster processing, since your first IF tests if CL3 is not equal to 0, you do not need the second IF, as the second IF will always be true since it will only occur when the first one is zero. So you could change your formula to be the following: =IF(CL3<>0,0,(E3-E4)*S4+U4) For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |