| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 |
|
#2
|
|||
|
|||
|
=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 . |
|
#3
|
|||
|
|||
|
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 . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Findlink Error | Links and Linking in Excel | |||
| Error when entering and exiting excel | Excel Discussion (Misc queries) | |||
| #DIV/0 Error | Excel Worksheet Functions | |||
| Please help correct a simple error | New Users to Excel | |||
| #REF error | Excel Worksheet Functions | |||
Linear Mode
