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