#VALUE!

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Pencil - 30 Jul 2006 05:17 GMT

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.

Reply to this Message

Peo Sjoblom - 30 Jul 2006 05:49 GMT

Try

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

Signature

Regards,

Peo Sjoblom

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

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

Reply to this Message

Ragdyer - 30 Jul 2006 05:55 GMT

Try this:

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

Signature

HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

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

Reply to this Message

Ron Rosenfeld - 30 Jul 2006 10:51 GMT

>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

Reply to this Message

Pencil - 30 Jul 2006 23:59 GMT

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

-----
Thanks everybody for your solutions. They all work.

Reply to this Message