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
|
|