If error function

G

Guest

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),"",(A4/A5))

Please Help!
Neil
 
N

Niek Otten

Hi Neil,

=IF(ISERROR(A4/A5),"",(A4/A5))

--
Kind regards,

Niek Otten


| 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),"",(A4/A5))
|
| Please Help!
| Neil
|
|
 
P

Per Erik Midtrød

You get the message beacuse you are referencing the cell containing
the formula, try this instead:= IF(ISERROR(A4/4);"";A4/4)

Per Erik
 
N

Niek Otten

Or, simpler, more direct,

=IF(A5=0,"",A4/A5)

--
Kind regards,

Niek Otten

| Hi Neil,
|
| =IF(ISERROR(A4/A5),"",(A4/A5))
|
| --
| Kind regards,
|
| Niek Otten
|
|
|| 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),"",(A4/A5))
||
|| Please Help!
|| Neil
||
||
|
|
 
G

Guest

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
 
B

Bob Phillips

=IF(A5=0,"",A4/A5)

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 
N

Niek Otten

It happens to all of us!

--
Kind regards,

Niek Otten

| 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
|
| "Niek Otten" wrote:
|
| > Hi Neil,
| >
| > =IF(ISERROR(A4/A5),"",(A4/A5))
| >
| > --
| > Kind regards,
| >
| > Niek Otten
| >
| >
| > | 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),"",(A4/A5))
| > |
| > | Please Help!
| > | Neil
| > |
| > |
| >
| >
| >
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

algebra by excel 3
Return Unique Entries Only 5
adding numbers in a column with dates 5
Cell referencing 10
COUNT function 2
INDIRECT Function 9
How to apply an automatic format to a column? 2
Comparing Data 4

Top