ISERROR function

  • Thread starter Thread starter Gotroots
  • Start date Start date
G

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