Here is a formula that with a Cell A2/B2. If there is an error (such as Div
0#) it inserts a blank, if there is no error it does shows the calculation.
does that help?

=IF(ISERR(A2/B2)=TRUE,"",A2/B2)

"Taru" wrote:


If a formula returns a number or an error message how do I use the error
message in a logical test.


--
Taru
------------------------------------------------------------------------
Taru's Profile: http://www.excelforum.com/member.php...o&userid=35494
View this thread: http://www.excelforum.com/showthread...hreadid=552702