Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|