View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Neil M
 
Posts: n/a
Default 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