Forum Discussion

Thomas Bryant's avatar
Thomas Bryant
Tin Contributor
Sep 25, 2017

Error Help

So I recently used the following formula in excel

=IF($Y$12=1,SUM('StableFord Scores'!$M2,'StrokePlay Scores'!$M2,IF($Y$11=1,SUM('StableFord Scores'!$L2,'StrokePlay Scores'!$L2,IF($Y$10=1,SUM('StableFord Scores'!$K2,'StrokePlay Scores'!$K2,IF($Y$9=1,SUM('StableFord Scores'!$J2,'StrokePlay Scores'!$J2,IF($Y$8=1,SUM('StableFord Scores'!$I2,'StrokePlay Scores'!$I2,IF($Y$7=1,SUM('StableFord Scores'!$H2,'StrokePlay Scores'!$H2,IF($Y$6=1,SUM('StableFord Scores'!$G2,'StrokePlay Scores'!$G2,IF($Y$5=1,SUM('StableFord Scores'!$F2,'StrokePlay Scores'!$F2,IF($Y$4=1,SUM('StableFord Scores'!$E2,'StrokePlay Scores'!$E2,IF($Y$3=1,SUM('StableFord Scores'!$D2,'StrokePlay Scores'!$D2,IF($Y$2=1,SUM('StableFord Scores'!$C2,'StrokePlay Scores'!$C2,IF($Y$1=1,SUM('StableFord Scores'!$B2,'StrokePlay Scores'!$B2))))))))))))))))))))))))

Y1 does=1 however C2 still says false.

Can anyone look and see if they can figure out what ive done wrong?

excel
Formulas and Functions

1 Reply

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor
    Sep 26, 2017

    Hi Thomas,

     

    Your formula is

    =IF($Y$12=1,<something>)

    since $Y$12=0 (condition FALSE) entire formula returns FALSE.