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