Login Page - Create Account

Support Board


Date/Time: Wed, 15 May 2024 23:14:32 +0000



Post From: Translate Excel Formula to SC Spreadsheet Formula?

[2020-01-08 17:00:59]
Sierra Chart Engineering - Posts: 104368
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