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