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