Excel calculating wrong

%3CLINGO-SUB%20id%3D%22lingo-sub-1597295%22%20slang%3D%22en-US%22%3EExcel%20calculating%20wrong%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1597295%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20all%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20having%20an%20IFERROR%20challenge.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECell%20E26%20contains%20the%20formula%3DIFERROR(C9%2BN9%2F%24W9%2C0)%3C%2FP%3E%3CP%3EC9%20%3D2%3C%2FP%3E%3CP%3EN9%20%3D%208%3C%2FP%3E%3CP%3EW9%20%3D%2061%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B2%2B8%3D10%26nbsp%3B%2010%2F61%3D0.1639%3C%2FP%3E%3CP%3EHowever%2C%20cell%26nbsp%3B%20E26%20is%20returning%20213.11%25%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1597295%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1597335%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20calculating%20wrong%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1597335%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F751940%22%20target%3D%22_blank%22%3E%40La_La2346%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EDivision%20has%20precedence%20above%20addition%2C%20so%20your%20formula%20adds%20N9%2F%24W9%20to%20C9%3C%2FP%3E%0A%3CP%3EIf%20you%20want%20to%20add%20C9%20and%20N9%20before%20dividing%20by%20W9%2C%20you%20must%20enclose%20C9%2BN9%20in%20parentheses%3A%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3DIFERROR((C9%2BN9)%2F%24W9%2C0)%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hello all,

 

I am having an IFERROR challenge.

 

Cell E26 contains the formula=IFERROR(C9+N9/$W9,0)

C9 =2

N9 = 8

W9 = 61     2+8=10  10/61=0.1639

However, cell  E26 is returning 213.11%

 

1 Reply

@La_La2346 

Division has precedence above addition, so your formula adds N9/$W9 to C9

If you want to add C9 and N9 before dividing by W9, you must enclose C9+N9 in parentheses:

 

=IFERROR((C9+N9)/$W9,0)