Excel calculating wrong

Copper 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)