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]

=IFERROR(IF(ERROR.TYPE(A1)=3,"#VALUE!",""),"")

<tbody>
</tbody>

 

[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.

=IFERROR(IF(ERROR.TYPE(A1)=3,"#VALUE!",""),"")

<tbody>
</tbody>

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