• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 472
  • Last Modified:

IF with ISERROR

Hi,

On row 15, i have an IF Statement highlighted red. It should be returning "Cleared" as its adjacent cel (BD15) is an error

What is wrong with the formula?
=IF(BD15="no change","No Change",IF(BD15="Changed","Re-assigned",IF(ISERROR(BD15),"Cleared","")))

Thanks
Seamus test.xls
0
Seamus2626
Asked:
Seamus2626
  • 2
1 Solution
 
StephenJRCommented:
Seamus - I think you just have to turn round (not sure why):

=IF(ISERROR(BD15),"Cleared",IF(BD15="no change","No Change",IF(BD15="Changed","Re-assigned","")))
0
 
StephenJRCommented:
I think because BD15 is an error, it throws out the checks so Excel basically thinks the result is an error so doesn't check your whole formula.
0
 
Seamus2626Author Commented:
perfect, thanks Stephen!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: C++ 11 Fundamentals

This course will introduce you to C++ 11 and teach you about syntax fundamentals.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now