Simple #DIV/0! error

[AMY Z.]

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

[Jason Morin]

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

[AMY Z.]

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