Simple #DIV/0! error

G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculations resulting in #DIV/0! 6
Avoiding redundant calculations 7
Error with sum formula in excel 2007 4
How to find average for grading? 3
IF statement with AND or OR? 7
How to not get '0' or '#DIV/0!' in a cell with a percentage formul 5
using if iserror on aonther sheet 2
If error function 6

Top