Forum Discussion

La_La2346's avatar
La_La2346
Copper Contributor
Aug 18, 2020

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%

 

excel

1 Reply

  • HansVogelaar's avatar
    HansVogelaar
    MVP
    Aug 18, 2020

    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)

Resources