software

This should be an easy one for me, but I'll be darned if I can figure it out.

I have 6 cells involved in one final answer.

A1 = (varies)
A2 = (varies)
A3 = (varies)
A4 = A1 * A3
A5 = varies
A6 = A4/A5

I keep getting the #DIV/0 error in A6

This is what I tried and it keeps giving me a circular reference message:

=IF(ISERROR(A6),quot;quot;,(A4/A5))

Please Help!
Neil
Hi Neil,

=IF(ISERROR(A4/A5),quot;quot;,(A4/A5))

--
Kind regards,

Niek Ottenquot;Neil Mquot; gt; wrote in message ...
| This should be an easy one for me, but I'll be darned if I can figure it out.
|
| I have 6 cells involved in one final answer.
|
| A1 = (varies)
| A2 = (varies)
| A3 = (varies)
| A4 = A1 * A3
| A5 = varies
| A6 = A4/A5
|
| I keep getting the #DIV/0 error in A6
|
| This is what I tried and it keeps giving me a circular reference message:
|
| =IF(ISERROR(A6),quot;quot;,(A4/A5))
|
| Please Help!
| Neil
|
|
You get the message beacuse you are referencing the cell containing
the formula, try this instead:= IF(ISERROR(A4/4);quot;quot;;A4/4)

Per ErikOn Wed, 26 Apr 2006 09:34:02 -0700, Neil M gt;
wrote:

gt;This should be an easy one for me, but I'll be darned if I can figure it out.
gt;
gt;I have 6 cells involved in one final answer.
gt;
gt;A1 = (varies)
gt;A2 = (varies)
gt;A3 = (varies)
gt;A4 = A1 * A3
gt;A5 = varies
gt;A6 = A4/A5
gt;
gt;I keep getting the #DIV/0 error in A6
gt;
gt;This is what I tried and it keeps giving me a circular reference message:
gt;
gt;=IF(ISERROR(A6),quot;quot;,(A4/A5))
gt;
gt;Please Help!
gt;Neil
gt;

Or, simpler, more direct,

=IF(A5=0,quot;quot;,A4/A5)

--
Kind regards,

Niek Otten

quot;Niek Ottenquot; gt; wrote in message ...
| Hi Neil,
|
| =IF(ISERROR(A4/A5),quot;quot;,(A4/A5))
|
| --
| Kind regards,
|
| Niek Otten
|
|
| quot;Neil Mquot; gt; wrote in message ...
|| This should be an easy one for me, but I'll be darned if I can figure it out.
||
|| I have 6 cells involved in one final answer.
||
|| A1 = (varies)
|| A2 = (varies)
|| A3 = (varies)
|| A4 = A1 * A3
|| A5 = varies
|| A6 = A4/A5
||
|| I keep getting the #DIV/0 error in A6
||
|| This is what I tried and it keeps giving me a circular reference message:
||
|| =IF(ISERROR(A6),quot;quot;,(A4/A5))
||
|| Please Help!
|| Neil
||
||
|
|
This ione of those moments when you read the answer and then get the guy next
to you to slap you. I didn't even see it when I was typing the question!

DUHHHHHHHHHHHHH!!!

Thank You Niek

quot;Niek Ottenquot; wrote:

gt; Hi Neil,
gt;
gt; =IF(ISERROR(A4/A5),quot;quot;,(A4/A5))
gt;
gt; --
gt; Kind regards,
gt;
gt; Niek Otten
gt;
gt;
gt; quot;Neil Mquot; gt; wrote in message ...
gt; | This should be an easy one for me, but I'll be darned if I can figure it out.
gt; |
gt; | I have 6 cells involved in one final answer.
gt; |
gt; | A1 = (varies)
gt; | A2 = (varies)
gt; | A3 = (varies)
gt; | A4 = A1 * A3
gt; | A5 = varies
gt; | A6 = A4/A5
gt; |
gt; | I keep getting the #DIV/0 error in A6
gt; |
gt; | This is what I tried and it keeps giving me a circular reference message:
gt; |
gt; | =IF(ISERROR(A6),quot;quot;,(A4/A5))
gt; |
gt; | Please Help!
gt; | Neil
gt; |
gt; |
gt;
gt;
gt;

=IF(A5=0,quot;quot;,A4/A5)

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;Neil Mquot; gt; wrote in message
...
gt; This should be an easy one for me, but I'll be darned if I can figure it
out.
gt;
gt; I have 6 cells involved in one final answer.
gt;
gt; A1 = (varies)
gt; A2 = (varies)
gt; A3 = (varies)
gt; A4 = A1 * A3
gt; A5 = varies
gt; A6 = A4/A5
gt;
gt; I keep getting the #DIV/0 error in A6
gt;
gt; This is what I tried and it keeps giving me a circular reference message:
gt;
gt; =IF(ISERROR(A6),quot;quot;,(A4/A5))
gt;
gt; Please Help!
gt; Neil
gt;
gt;
It happens to all of us!

--
Kind regards,

Niek Otten

quot;Neil Mquot; gt; wrote in message ...
| This ione of those moments when you read the answer and then get the guy next
| to you to slap you. I didn't even see it when I was typing the question!
|
| DUHHHHHHHHHHHHH!!!
|
| Thank You Niek
|
| quot;Niek Ottenquot; wrote:
|
| gt; Hi Neil,
| gt;
| gt; =IF(ISERROR(A4/A5),quot;quot;,(A4/A5))
| gt;
| gt; --
| gt; Kind regards,
| gt;
| gt; Niek Otten
| gt;
| gt;
| gt; quot;Neil Mquot; gt; wrote in message ...
| gt; | This should be an easy one for me, but I'll be darned if I can figure it out.
| gt; |
| gt; | I have 6 cells involved in one final answer.
| gt; |
| gt; | A1 = (varies)
| gt; | A2 = (varies)
| gt; | A3 = (varies)
| gt; | A4 = A1 * A3
| gt; | A5 = varies
| gt; | A6 = A4/A5
| gt; |
| gt; | I keep getting the #DIV/0 error in A6
| gt; |
| gt; | This is what I tried and it keeps giving me a circular reference message:
| gt; |
| gt; | =IF(ISERROR(A6),quot;quot;,(A4/A5))
| gt; |
| gt; | Please Help!
| gt; | Neil
| gt; |
| gt; |
| gt;
| gt;
| gt;