Forum Discussion

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('Stabl...

golf.xlsx75 KB

excel

Formulas and Functions

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.