ExcelBanter - If error function

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - If error function (https://www.excelbanter.com/excel-worksheet-functions/85403-if-error-function.html)

Neil M

If error function

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

Niek Otten

If error function

Per Erik Midtrød

If error function

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

Per Erik

On Wed, 26 Apr 2006 09:34:02 -0700, Neil M
wrote:

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

Niek Otten

If error function

Or, simpler, more direct,

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

--
Kind regards,

Niek Otten

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

Neil M

If error function

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

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

Bob Phillips

If error function

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

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

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

Please Help!
Neil

Niek Otten

If error function

All times are GMT +1. The time now is 09:14 AM.