View Single Post
  #2   Report Post  
Jason Morin
 
Posts: n/a
Default

=IF(A2=0,0,A1/A2)

HTH
Jason
Atlanta, GA

-----Original Message-----
Hi,
A1=0
A2=0
A3=A1/A2
A3 returns the #DIV/0! error.
What are the functions or syntax I have to use for A3 to

return 0 if A1 and
A2 are 0?

I looked in Excel help and tried nesting the IF function

and ISERROR
function but I can't get the syntax right.

Thanks for your time, whilst everyone have a nice

weekend,
Amy

.