Forum Discussion
Excel calculating wrong
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%
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)