evaluate #¡VALUE! and #!DIV/0! and other errors....
 

hi by sample:

in cell a1 type: 5
in cell a2 type: r

in cell a4 type: =a1+a2

these produce an error #!VALUE! ... i need something like that:

in cell a4:

=if((a1+a2)=#!VALUE!,-50000, a1+a2)


if exist any error i need a -50000 ...

understood?

thanks


--
jamiguel77
------------------------------------------------------------------------
jamiguel77's Profile: http://www.excelforum.com/member.php...o&userid=31521
View this thread: http://www.excelforum.com/showthread...hreadid=512096

evaluate #¡VALUE! and #!DIV/0! and other errors....
 

Hi!

Try this:

=IF(ISERROR(A1+A2),-50000,A1+A2)

Biff

"jamiguel77" wrote
in message ...

hi by sample:

in cell a1 type: 5
in cell a2 type: r

in cell a4 type: =a1+a2

these produce an error #!VALUE! ... i need something like that:

in cell a4:

=if((a1+a2)=#!VALUE!,-50000, a1+a2)


if exist any error i need a -50000 ...

understood?

thanks


--
jamiguel77
------------------------------------------------------------------------
jamiguel77's Profile:
http://www.excelforum.com/member.php...o&userid=31521
View this thread: http://www.excelforum.com/showthread...hreadid=512096