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
|