Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |