Support Board
Date/Time: Wed, 15 Jan 2025 16:00:05 +0000
Does ISERROR work?
View Count: 1239
| [2017-08-04 14:51:27] |
| cgarrad - Posts: 27 |
|
=ISERROR(P4) just gives a #NAME? error https://www.sierrachart.com/index.php?page=doc/SpreadsheetFunctions.html#ISERROR_Function Also do you support IFERROR and IFNA? |
| [2017-08-04 17:56:44] |
| Jeffrey - Posts: 2195 |
|
This is a documentation error. The Spreadsheet Functions page will be updated. ISERROR does not exist by that name. The function is ISERR, which has the functionality of "Returns TRUE if the given Value is an error value type. Otherwise returns FALSE." Also do you support IFERROR and IFNA?
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) |
 Spreadsheet example ISERR NA.PNG / V - Attached On 2017-08-04 17:56:03 UTC - Size: 6.55 KB - 303 views |
To post a message in this thread, you need to log in with your Sierra Chart account: