Support Board
Support Board
Search Board
Control Panel
View My Posts / Threads
Direct MessagesDate/Time: Mon, 29 Apr 2024 08:12:30 +0000
Translate Excel Formula to SC Spreadsheet Formula?
View Count: 856
| [2020-01-05 10:59:31] |
| Halco - Posts: 92 |
|
I'm trying to use this formula in SC: =IF(K3=0,0,IFERROR(L2+AD3,AD3)) I thought I was supposed to substitute ISERR for IFERROR but that didn't work. Thanks. |
| [2020-01-08 17:00:59] |
| |
|
This is a user contributed response and has not been verified by us: IFERROR(A, B, C) can be written as IF(ERR(A), B, C).
IFNA(A, B, C) can be written as IF(A=#N/A, B, C) Reference: https://www.sierrachart.com/index.php?page=doc/SpreadsheetFunctions.html#ISERR_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: