| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Using ISERROR to Solve #DIV/0 in a formula
Hi
Apologies if i am repeating someone elses question, but can someone help me enter the ISERROR function into this formula to get rid of the #DIV/0 message? =IF(G43+C43=0,0,(G43/C43)) Basically cell C43 is a zero, so when the formula calculates the last section I am getting the #DIV/0 error. Can I add the ISERROR function to display a '0' instead or anything else for that matter? Thanks in advance for your help. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Using ISERROR to Solve #DIV/0 in a formula
You have a few alternatives:
=IF(G43+C43=0,0,if(iserror(G43/C43),"some message",G43/c43) =IF(G43+C43=0,0,if(C43=0,"some message",G43/c43) =IF(OR(G43+C43=0,C43=0),0,G43/C43) "Leigh Douglass" wrote: Hi Apologies if i am repeating someone elses question, but can someone help me enter the ISERROR function into this formula to get rid of the #DIV/0 message? =IF(G43+C43=0,0,(G43/C43)) Basically cell C43 is a zero, so when the formula calculates the last section I am getting the #DIV/0 error. Can I add the ISERROR function to display a '0' instead or anything else for that matter? Thanks in advance for your help. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Using ISERROR to Solve #DIV/0 in a formula
Try this:
=IF(OR(G43+C43=0,C43=0),0,(G43/C43)) -- HTH, RD ================================================== === Please keep all correspondence within the Group, so all may benefit! ================================================== === "Leigh Douglass" <Leigh wrote in message ... Hi Apologies if i am repeating someone elses question, but can someone help me enter the ISERROR function into this formula to get rid of the #DIV/0 message? =IF(G43+C43=0,0,(G43/C43)) Basically cell C43 is a zero, so when the formula calculates the last section I am getting the #DIV/0 error. Can I add the ISERROR function to display a '0' instead or anything else for that matter? Thanks in advance for your help. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Using ISERROR to Solve #DIV/0 in a formula
If you want to use ISERROR you can use
=IF(G43+C43=0,0,IF(ISERROR(G43/C43),"error",G43/C43)) but that may get confused with other sorts of error. If you are merely trying to cope with the divide by zero, then perhaps better to use =IF(G43+C43=0,0,IF(C43=0,"divide error",G43/C43)) -- David Biddulph "Leigh Douglass" <Leigh wrote in message ... Hi Apologies if i am repeating someone elses question, but can someone help me enter the ISERROR function into this formula to get rid of the #DIV/0 message? =IF(G43+C43=0,0,(G43/C43)) Basically cell C43 is a zero, so when the formula calculates the last section I am getting the #DIV/0 error. Can I add the ISERROR function to display a '0' instead or anything else for that matter? Thanks in advance for your help. |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Using ISERROR to Solve #DIV/0 in a formula
=IF(C43=0,0,G43/C43)
"Leigh Douglass" wrote: Hi Apologies if i am repeating someone elses question, but can someone help me enter the ISERROR function into this formula to get rid of the #DIV/0 message? =IF(G43+C43=0,0,(G43/C43)) Basically cell C43 is a zero, so when the formula calculates the last section I am getting the #DIV/0 error. Can I add the ISERROR function to display a '0' instead or anything else for that matter? Thanks in advance for your help. |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Using ISERROR to Solve #DIV/0 in a formula
Excel 2003: =IF(G43+C43=0,0,IF(C43=0,0,G43/C43))
Excel 2007: =IFERROR(IF(G43+C43=0,0,(G43/C43)),0) "Leigh Douglass" wrote: Hi Apologies if i am repeating someone elses question, but can someone help me enter the ISERROR function into this formula to get rid of the #DIV/0 message? =IF(G43+C43=0,0,(G43/C43)) Basically cell C43 is a zero, so when the formula calculates the last section I am getting the #DIV/0 error. Can I add the ISERROR function to display a '0' instead or anything else for that matter? Thanks in advance for your help. |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Using ISERROR to Solve #DIV/0 in a formula
Toppers, you don't provide for C34= 1 and G34= -1
1 + (-1) =0 1 / (-1) = (-1) "Toppers" wrote: =IF(C43=0,0,G43/C43) "Leigh Douglass" wrote: Hi Apologies if i am repeating someone elses question, but can someone help me enter the ISERROR function into this formula to get rid of the #DIV/0 message? =IF(G43+C43=0,0,(G43/C43)) Basically cell C43 is a zero, so when the formula calculates the last section I am getting the #DIV/0 error. Can I add the ISERROR function to display a '0' instead or anything else for that matter? Thanks in advance for your help. |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Using ISERROR to Solve #DIV/0 in a formula
The "G43+C43" test is totally redundant. If C43 is zero, then G43 must be
zero and vice versa. "Toppers" wrote: =IF(C43=0,0,G43/C43) "Leigh Douglass" wrote: Hi Apologies if i am repeating someone elses question, but can someone help me enter the ISERROR function into this formula to get rid of the #DIV/0 message? =IF(G43+C43=0,0,(G43/C43)) Basically cell C43 is a zero, so when the formula calculates the last section I am getting the #DIV/0 error. Can I add the ISERROR function to display a '0' instead or anything else for that matter? Thanks in advance for your help. |
|
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Using ISERROR to Solve #DIV/0 in a formula
Duke
You are a life saver. Thanks very much. "Duke Carey" wrote: You have a few alternatives: =IF(G43+C43=0,0,if(iserror(G43/C43),"some message",G43/c43) =IF(G43+C43=0,0,if(C43=0,"some message",G43/c43) =IF(OR(G43+C43=0,C43=0),0,G43/C43) "Leigh Douglass" wrote: Hi Apologies if i am repeating someone elses question, but can someone help me enter the ISERROR function into this formula to get rid of the #DIV/0 message? =IF(G43+C43=0,0,(G43/C43)) Basically cell C43 is a zero, so when the formula calculates the last section I am getting the #DIV/0 error. Can I add the ISERROR function to display a '0' instead or anything else for that matter? Thanks in advance for your help. |
|
#10
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Using ISERROR to Solve #DIV/0 in a formula
Got me!!! OK!
"Tevuna" wrote: Toppers, you don't provide for C34= 1 and G34= -1 1 + (-1) =0 1 / (-1) = (-1) "Toppers" wrote: =IF(C43=0,0,G43/C43) "Leigh Douglass" wrote: Hi Apologies if i am repeating someone elses question, but can someone help me enter the ISERROR function into this formula to get rid of the #DIV/0 message? =IF(G43+C43=0,0,(G43/C43)) Basically cell C43 is a zero, so when the formula calculates the last section I am getting the #DIV/0 error. Can I add the ISERROR function to display a '0' instead or anything else for that matter? Thanks in advance for your help. |
|
#11
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Using ISERROR to Solve #DIV/0 in a formula
Yeah, but the fellow wants a zero even when C43 is not zero; in cased where
C43 and G43 cancel each other by opposite signs. "Toppers" wrote: The "G43+C43" test is totally redundant. If C43 is zero, then G43 must be zero and vice versa. "Toppers" wrote: =IF(C43=0,0,G43/C43) "Leigh Douglass" wrote: Hi Apologies if i am repeating someone elses question, but can someone help me enter the ISERROR function into this formula to get rid of the #DIV/0 message? =IF(G43+C43=0,0,(G43/C43)) Basically cell C43 is a zero, so when the formula calculates the last section I am getting the #DIV/0 error. Can I add the ISERROR function to display a '0' instead or anything else for that matter? Thanks in advance for your help. |
|
#12
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Using ISERROR to Solve #DIV/0 in a formula
"Toppers" wrote...
=IF(C43=0,0,G43/C43) .... Or avoid all function calls. =(C43<0)*G42/(C43+(C43=0)) Not recommended, just FTHOI. |
|
#13
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Using ISERROR to Solve #DIV/0 in a formula
maybe
=if(or(c43=0,C43+G43=0),0,g4/c43) "Leigh Douglass" wrote: Hi Apologies if i am repeating someone elses question, but can someone help me enter the ISERROR function into this formula to get rid of the #DIV/0 message? =IF(G43+C43=0,0,(G43/C43)) Basically cell C43 is a zero, so when the formula calculates the last section I am getting the #DIV/0 error. Can I add the ISERROR function to display a '0' instead or anything else for that matter? Thanks in advance for your help. |
|
#14
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Using ISERROR to Solve #DIV/0 in a formula
"bj" wrote...
maybe =if(or(c43=0,C43+G43=0),0,g4/c43) .... The OP was confused when giving C43+G43=0 in the origin example formula. That formula didn't come close to matching the prose specs. There's no need to check C43+G43=0 unless the OP doesn't want instances of C43 < 0 and C43 = -G43 to result in 0 rather than -1. Off the top of my head, I can't think of any reason why the OP would want 0 as result instead of -1 but would want other negative ratios when C43 is nonzero and has the opposite sign of G43. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to use Excel to solve inequality formula? | Excel Discussion (Misc queries) | |||
| formula to solve | Excel Discussion (Misc queries) | |||
| Formula to solve | Excel Discussion (Misc queries) | |||
| Int Iserror Len Mid Find formula | Excel Worksheet Functions | |||
| simple average formula...can you solve it in principle? | Excel Discussion (Misc queries) | |||
Linear Mode
