ISERROR function

[Gotroots]

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]

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

 

[NBVC]

IFERROR() is an XL2007 function:


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

or if not in XL2007,


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

--
NBV

Where there is a will there are many ways.

'The Code Cage' (http://www.thecodecage.com

 

[Ms-Exl-Learner]

=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!