SOLVED

How Do I Enter IFERROR For Following Cell?

%3CLINGO-SUB%20id%3D%22lingo-sub-1761649%22%20slang%3D%22en-US%22%3EHow%20Do%20I%20Enter%20IFERROR%20For%20Following%20Cell%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1761649%22%20slang%3D%22en-US%22%3E%3CP%3EI'm%20trying%20to%20make%20a%20cell%20return%20a%200%20(zero)%20instead%20of%20the%20default%20%23DIV%2F0!%20but%20one%20of%20my%20cells%20has%20a%20longer%20formula%20and%20the%20standard%20IFERROR%20I%20try%20to%20use%20isn't%20working.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%231%3A%3C%2FP%3E%3CP%3EFor%20example%2C%20it%20works%20on%20the%20following%20cell...%3C%2FP%3E%3CP%3E%3DIFERROR(I5*%24B%245%2FI4%2C0)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%232%3A%3C%2FP%3E%3CP%3EBut%20it%20doesn't%20work%20on%20the%20following%20cell...%3C%2FP%3E%3CP%3E%3DI12%2F(J29%2BQ29%2BX29%2BAE29%2BAL29%2BAS29%2BAZ29)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHow%20do%20I%20type%20it%20to%20get%20it%20to%20work%20on%20example%20%232%20above%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20tried%20typing%20it%20as%20follows...%3C%2FP%3E%3CP%3E%3DIFERROR(I12%2F(J29%2BQ29%2BX29%2BAE29%2BAL29%2BAS29%2BAZ29%2C0)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E...but%20this%20didn't%20work.%20I%20tried%20moving%20the%20%2C0%20around%20but%20nothing%20works.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1761649%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1761836%22%20slang%3D%22en-US%22%3ERe%3A%20How%20Do%20I%20Enter%20IFERROR%20For%20Following%20Cell%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1761836%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F825432%22%20target%3D%22_blank%22%3E%40Nickers24_2020%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3DIFERROR(I12%2F(J29%2BQ29%2BX29%2BAE29%2BAL29%2BAS29%2BAZ29)%2C0)%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1761839%22%20slang%3D%22en-US%22%3ERe%3A%20How%20Do%20I%20Enter%20IFERROR%20For%20Following%20Cell%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1761839%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F825432%22%20target%3D%22_blank%22%3E%40Nickers24_2020%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHi%20there%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIfError%20function%20is%20working%20when%20there%20is%20result%20which%20you%20want%20to%20change.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EActually%2C%20it%20works%20well%20in%20my%20case.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20note%20the%20attached%20file.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20will%20be%20sure%20of%20it.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EGood%20like.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1761841%22%20slang%3D%22en-US%22%3ERe%3A%20How%20Do%20I%20Enter%20IFERROR%20For%20Following%20Cell%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1761841%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F825432%22%20target%3D%22_blank%22%3E%40Nickers24_2020%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3DIFERROR(B2%2F(C4%2BD4%2BE4%2BF4%2BG4)%2C%200)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Edgar_Martin_0-1602191963118.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F225213i9E89829A77C4FF68%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22Edgar_Martin_0-1602191963118.png%22%20alt%3D%22Edgar_Martin_0-1602191963118.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1762255%22%20slang%3D%22en-US%22%3ERe%3A%20How%20Do%20I%20Enter%20IFERROR%20For%20Following%20Cell%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1762255%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F127945%22%20target%3D%22_blank%22%3E%40Hans%20Vogelaar%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYep%2C%20that%20worked!%20THANK%20YOU!!!!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESo%20I%20just%20needed%20to%20close%20off%20the%20parenthesis!%20About%20this...get%20an%20a%20straight%20forward%20answer%20that%20works%20and%20asap!!!!%20Wish%20everything%20worked%20like%20this.%20%3CLI-EMOJI%20id%3D%22lia_grinning-face-with-big-eyes%22%20title%3D%22%3Agrinning_face_with_big_eyes%3A%22%3E%3C%2FLI-EMOJI%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20everyone%20for%20your%20help%20but%20I%20have%20to%20warn%20ya...now%20that%20I%20know%20there's%20some%20good%20talent%20in%20here...I'll%20be%20back%20asking%20more%20questions%2C%20needing%20more%20help%20-%20lol!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20again!%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

I'm trying to make a cell return a 0 (zero) instead of the default #DIV/0! but one of my cells has a longer formula and the standard IFERROR I try to use isn't working.

 

#1:

For example, it works on the following cell...

=IFERROR(I5*$B$5/I4,0)

 

#2:

But it doesn't work on the following cell...

=I12/(J29+Q29+X29+AE29+AL29+AS29+AZ29)

 

How do I type it to get it to work on example #2 above?

 

I tried typing it as follows...

=IFERROR(I12/(J29+Q29+X29+AE29+AL29+AS29+AZ29,0)

 

...but this didn't work. I tried moving the ,0 around but nothing works.

4 Replies
Best Response confirmed by Nickers24_2020 (New Contributor)
Solution

@Nickers24_2020 

 

=IFERROR(I12/(J29+Q29+X29+AE29+AL29+AS29+AZ29),0)

@Nickers24_2020 

Hi there,

 

IfError function is working when there is result which you want to change.

 

Actually, it works well in my case.

 

Please note the attached file.

 

You will be sure of it.

 

Good like.

 

@Nickers24_2020 

 

=IFERROR(B2/(C4+D4+E4+F4+G4), 0)

 

Edgar_Martin_0-1602191963118.png

 

@Hans Vogelaar 

 

Yep, that worked! THANK YOU!!!!

 

So I just needed to close off the parenthesis! About this...get an a straight forward answer that works and asap!!!! Wish everything worked like this.

 

Thank you everyone for your help but I have to warn ya...now that I know there's some good talent in here...I'll be back asking more questions, needing more help - lol!

 

Thanks again!