| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Zero divided by Zero
Is there a formula that will allow zero divied by zero to equal zero
rather than giving an error? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Zero divided by Zero
Maybe use an IF statement to check if the divisor is 0
A1=0 or any number B1=0 In C1, enter =IF(B1=0, 0, A1/B1) -- Hope that helps. Vergel Adriano "TheNYCer" wrote: Is there a formula that will allow zero divied by zero to equal zero rather than giving an error? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Zero divided by Zero
you could also nest two IF's...
=IF(B1=0, 0, IF(A1=0,0,A1/B1)) that way if either cell is equal to zero it will not return the divide by zero error but instead return 0. "Vergel Adriano" wrote: Maybe use an IF statement to check if the divisor is 0 A1=0 or any number B1=0 In C1, enter =IF(B1=0, 0, A1/B1) -- Hope that helps. Vergel Adriano "TheNYCer" wrote: Is there a formula that will allow zero divied by zero to equal zero rather than giving an error? |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Zero divided by Zero
Hi Stephen,
I believe the problem happens only when you divide a number by 0. 0 divided by a non 0 value will equal to 0, so you need not check if A1 is 0. -- Hope that helps. Vergel Adriano "Stephen" wrote: you could also nest two IF's... =IF(B1=0, 0, IF(A1=0,0,A1/B1)) that way if either cell is equal to zero it will not return the divide by zero error but instead return 0. "Vergel Adriano" wrote: Maybe use an IF statement to check if the divisor is 0 A1=0 or any number B1=0 In C1, enter =IF(B1=0, 0, A1/B1) -- Hope that helps. Vergel Adriano "TheNYCer" wrote: Is there a formula that will allow zero divied by zero to equal zero rather than giving an error? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Revenue divided by Day How? | Excel Discussion (Misc queries) | |||
| 365-day divided into 13 periods | Excel Discussion (Misc queries) | |||
| returning zero on pct divided by zero | Excel Discussion (Misc queries) | |||
| Amount is divided by 100 | Excel Discussion (Misc queries) | |||
| Why are my cell being divided by 100? | Excel Worksheet Functions | |||
Linear Mode
