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