If/is #value! Then [action]?

[MEUserII]

Is there a way to write an IF formula or an IS formula that checks only for the error #VALUE! (and no other error like #REF!/#NA!...etc), and then executes an action?

For example something like: IF( ( (A1)=(#VALUE!) ), ("#YES VALUE! ERROR"), ("NO #VALUE! ERROR) ) ?

OR

Something like: ISVALUEERROR(A1)=#VALUE! , which would return TRUE/FALSE depending on if A1=#VALUE! ?

 

[Rick Rothstein]

Use the ERROR.TYPE function...

=IF(ERROR.TYPE(A1)=3,"Yes #Value Error","No #Value Error")

 

[jim may]

[TABLE="width: 72"]
<tbody>[TR]
[TD="class: xl63, width: 72"]=IFERROR(IF(ERROR.TYPE(A1)=3,"#VALUE!",""),"")[/TD]
[/TR]
</tbody>[/TABLE]

 

[MEUserII]

Use the ERROR.TYPE function...

=IF(ERROR.TYPE(A1)=3,"Yes #Value Error","No #Value Error")

Thank you so much for the help with this as I was not aware of the ERROR.TYPE() function.

[TABLE="width: 72"]
<tbody>[TR]
[TD="class: xl63, width: 72"]=IFERROR(IF(ERROR.TYPE(A1)=3,"#VALUE!",""),"")[/TD]
[/TR]
</tbody>[/TABLE]

I will try this to see how it works, and will follow up.