Support Board
Date/Time: Mon, 20 Jan 2025 16:54:45 +0000
Spreadsheet
View Count: 646
| [2018-06-27 18:17:58] |
| User123235 - Posts: 46 |
|
Hi, how one go about hiding, removing zero's from a data column so I wont get a DIV/0 error on a formula? I searched all threads and no luck, thanks in advance. |
| [2018-06-27 19:26:11] |
| |
|
Usually the way this would be solved is to use the IF function which can use a different formula in the case where a particular cell it is referencing, is 0. Refer to: https://www.sierrachart.com/index.php?page=doc/SpreadsheetFunctions.html#IF_Function Sierra Chart Support - Engineering Level Your definitive source for support. Other responses are from users. Try to keep your questions brief and to the point. Be aware of support policy: https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation For the most reliable, advanced, and zero cost futures order routing, *change* to the Teton service: Sierra Chart Teton Futures Order Routing |
To post a message in this thread, you need to log in with your Sierra Chart account: