From 8322ff882f06c6c92e4c9d9e4bf762e06a5a754c Mon Sep 17 00:00:00 2001 From: Olivier Hallot Date: Thu, 23 Apr 2015 21:51:23 -0300 Subject: tdf#64773 Help pages for IFNA and IFERROR functions Help entries for IFNA and IFERROR Calc functions Change-Id: I19c03ef50af17dc70fe45c36e4589c1f267800f9 Reviewed-on: https://gerrit.libreoffice.org/15503 Reviewed-by: Olivier Hallot Tested-by: Olivier Hallot --- source/text/scalc/01/04060104.xhp | 44 +++++++++++++++++++++++++++++++++++---- 1 file changed, 40 insertions(+), 4 deletions(-) diff --git a/source/text/scalc/01/04060104.xhp b/source/text/scalc/01/04060104.xhp index 9c8f52b5d3..023fca52d2 100644 --- a/source/text/scalc/01/04060104.xhp +++ b/source/text/scalc/01/04060104.xhp @@ -1,6 +1,6 @@ - + - - + + Information Functions @@ -32,7 +32,7 @@ functions; information functions Information Functions -This category contains the Information functions. +This category contains the Information functions.
@@ -354,6 +354,25 @@ =ISERROR(C9) where cell C9 contains =NA() returns TRUE.
+
+IFERROR function +testing;general errors + + +IFERROR +Returns the value if the cell does not contains an error value, or the alternative value if it does. +Syntax +IFERROR(Value;Alternate_value) + +Value is the value or expression to be be returned if it does not equal or result in an error. + +Alternate_value is the value or expression to be be returned if the expression or value of Value does equal or result in an error. +Example + +=IFERROR(C8;C9) where cell C8 contains =1/0 returns the value of C9, because 1/0 is an error. + +=IFERROR(C8;C9) where cell C8 contains 13 returns 13, the value of C8, which is not an error. +
ISFORMULA function recognizing formula cells @@ -480,6 +499,23 @@ =ISNA(D3) returns FALSE as a result.
+
+IFNA function +#N/A error;testing + + +IFNA +Returns the value if the cell does not contains the #N/A (value not available) error value, or the alternative value if it does. +Syntax +IFNA(Value;Alternate_value) + +Value is the value or expression to be be returned if it does not equal or result in an #N/A error. + +Alternate_value is the value or expression to be be returned if the expression or value of Value does equal or result in an #N/A error. +Example + +=IFNA(D3;D4) returns the value of D3 if D3 does not result in an #N/A error, or D4 if it does. +
ISTEXT function cell contents;text -- cgit v1.2.3