Simple #DIV/0! error
 

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

=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

.

Thank you Mr. Morin.

"Jason Morin" wrote:

=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

.