ExcelBanter - ISERROR function

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - ISERROR function (https://www.excelbanter.com/excel-worksheet-functions/252565-iserror-function.html)

Gotroots

ISERROR function

I want to add in ISERROR function into the following formula

=(D6-C6)-F6

Here is my attempt:

=(IFERROR(D6-C6)-F6)),"",(D6-C6)-F6

Thank you

Lars-Åke Aspelin[_2_]

ISERROR function

On Wed, 6 Jan 2010 04:47:01 -0800, Gotroots
wrote:

I want to add in ISERROR function into the following formula

=(D6-C6)-F6

Here is my attempt:

=(IFERROR(D6-C6)-F6)),"",(D6-C6)-F6

Thank you

You mix ISERROR and IFERROR.

Either use this

=IFERROR((D6-C6)-F6,"")

or this:

=IF(ISERROR((D6-C6)-F6),"",(D6-C6)-F6)

Hope this helps / Lars-Åke

Ms-Exl-Learner

ISERROR function

=IF(ISERROR((D6-C6)-F6),"",(D6-C6)-F6)
ISERROR - Value refers to any error value (#N/A, #VALUE!, #REF!, #DIV/0!,
#NUM!, #NAME?, or #NULL!).

=IF(ISERR((D6-C6)-F6),"",(D6-C6)-F6)
ISERR - Value refers to any error value except #N/A.

Remember to Click Yes, if this post helps!

--------------------
(Ms-Exl-Learner)
--------------------

"Gotroots" wrote:

I want to add in ISERROR function into the following formula

=(D6-C6)-F6

Here is my attempt:

=(IFERROR(D6-C6)-F6)),"",(D6-C6)-F6

Thank you

All times are GMT +1. The time now is 10:18 PM.