#VALUE!

[Pencil]

I want A1 to report an error that is in A6 but my formula doesn't work.
A6 reads: #VALUE!
The formula A1 is =IF(AN6=#VALUE!,"You messed up","")

Help.

 

[Peo Sjoblom]

Try

=IF(ISERROR(AN6),"You messed up","")


--


Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com

 

[Ragdyer]

Try this:

=IF(ISERR(A6),"You Messed Up","")

 

[Ron Rosenfeld]

I want A1 to report an error that is in A6 but my formula doesn't work.
A6 reads: #VALUE!
The formula A1 is =IF(AN6=#VALUE!,"You messed up","")

Help.

A little more involved, if you want to test ONLY for a #VALUE! error:

=IF(ISERR(A6),IF(ERROR.TYPE(A6)=3,"You Messed Up","Not Value Error"),"OK")


--ron

 

[Pencil]

I want A1 to report an error that is in A6 but my formula doesn't work.
A6 reads: #VALUE!
The formula A1 is =IF(AN6=#VALUE!,"You messed up","")

Help.