ISERROR function

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
 
L

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
 
M

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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

dynamic chart- curve drops to zero ( Line) 0
Copy Formula 3
SUMPRODUCT 0
Removal of Zero 4
If statements in Data Validation 7
If statement 2
IF function question 4
someone please shorten this formula... 6

Top