Aug 18 2020 01:38 PM
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%
Aug 18 2020 01:59 PM
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)