software

Hello,

My title asks my question, but we have a link that pulls in an answer
from another sheet that is #div/0! on the other sheet, but I can't
change the data on the sheet that has the #div/0! error. So I am
trying to write an if statment that gives 0 as a result instead of the
#div/0! error. Any ideas?--
caliskier
------------------------------------------------------------------------
caliskier's Profile: www.excelforum.com/member.php...oamp;userid=25887
View this thread: www.excelforum.com/showthread...hreadid=520832=IF(ISERROR(Sheet2!A1),quot;quot;,Sheet2!A1)

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

quot;caliskierquot; gt; wrote
in message ...
gt;
gt; Hello,
gt;
gt; My title asks my question, but we have a link that pulls in an answer
gt; from another sheet that is #div/0! on the other sheet, but I can't
gt; change the data on the sheet that has the #div/0! error. So I am
gt; trying to write an if statment that gives 0 as a result instead of the
gt; #div/0! error. Any ideas?
gt;
gt;
gt; --
gt; caliskier
gt; ------------------------------------------------------------------------
gt; caliskier's Profile:
www.excelforum.com/member.php...oamp;userid=25887
gt; View this thread: www.excelforum.com/showthread...hreadid=520832
gt;
=IF(ISERROR(cell_ref),0,cell_ref)

Regards

Trevorquot;caliskierquot; gt; wrote
in message ...
gt;
gt; Hello,
gt;
gt; My title asks my question, but we have a link that pulls in an answer
gt; from another sheet that is #div/0! on the other sheet, but I can't
gt; change the data on the sheet that has the #div/0! error. So I am
gt; trying to write an if statment that gives 0 as a result instead of the
gt; #div/0! error. Any ideas?
gt;
gt;
gt; --
gt; caliskier
gt; ------------------------------------------------------------------------
gt; caliskier's Profile:
gt; www.excelforum.com/member.php...oamp;userid=25887
gt; View this thread: www.excelforum.com/showthread...hreadid=520832
gt;
Hi!

Try this:

A1 = #DIV/0!

=IF(ISERROR(A1),0,your_formula_here))

Biff

quot;caliskierquot; gt; wrote
in message ...
gt;
gt; Hello,
gt;
gt; My title asks my question, but we have a link that pulls in an answer
gt; from another sheet that is #div/0! on the other sheet, but I can't
gt; change the data on the sheet that has the #div/0! error. So I am
gt; trying to write an if statment that gives 0 as a result instead of the
gt; #div/0! error. Any ideas?
gt;
gt;
gt; --
gt; caliskier
gt; ------------------------------------------------------------------------
gt; caliskier's Profile:
gt; www.excelforum.com/member.php...oamp;userid=25887
gt; View this thread: www.excelforum.com/showthread...hreadid=520832
gt;
On Thu, 9 Mar 2006 17:12:55 -0600, caliskier
gt; wrote:

gt;
gt;Hello,
gt;
gt;My title asks my question, but we have a link that pulls in an answer
gt;from another sheet that is #div/0! on the other sheet, but I can't
gt;change the data on the sheet that has the #div/0! error. So I am
gt;trying to write an if statment that gives 0 as a result instead of the
gt;#div/0! error. Any ideas?

=IF(ERROR.TYPE(cell_ref)=2,0,A12)

The other responses will result in a 0 for any error. However, this formula
should be specific for a #DIV/0 error.--ron


Thanks all, great helped alot!!--
caliskier
------------------------------------------------------------------------
caliskier's Profile: www.excelforum.com/member.php...oamp;userid=25887
View this thread: www.excelforum.com/showthread...hreadid=520832On Thu, 09 Mar 2006 19:17:14 -0500, Ron Rosenfeld gt;
wrote:

gt;On Thu, 9 Mar 2006 17:12:55 -0600, caliskier
gt; wrote:
gt;
gt;gt;
gt;gt;Hello,
gt;gt;
gt;gt;My title asks my question, but we have a link that pulls in an answer
gt;gt;from another sheet that is #div/0! on the other sheet, but I can't
gt;gt;change the data on the sheet that has the #div/0! error. So I am
gt;gt;trying to write an if statment that gives 0 as a result instead of the
gt;gt;#div/0! error. Any ideas?
gt;
gt;=IF(ERROR.TYPE(cell_ref)=2,0,A12)
gt;
gt;The other responses will result in a 0 for any error. However, this formula
gt;should be specific for a #DIV/0 error.
gt;
gt;
gt;--ron

That should be:

=IF(ERROR.TYPE(cell_ref)=2,0,cell_ref)--ron