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
Click to expand...


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

Copy Formula 3
Help with Time Sheet 5
If statement 2
If statements in Data Validation 7
Designating color in one cell based on data entered in another cel 3
Timesheet Formula 4
Sum total formula for adding 2 columnson time sheet 1
IF function question 4

Top