IF statement error question

[jmcclain]

I am trying to write an IF THEN argument such as..

=IF((B11-(C11:H11))=0,"YES","NO"

Where a value of YES will be returned if the condition is = 0 and a value of
NO will be returned if the condition is not equal to 0.

Where B11 to G11 are input values and H11 is the result of a formula
calculation.

I keep getting a #Value error...

Can anyone suggest a fix?

 

[Guest]

=IF(B11-SUM(C11:H11)=0,"yes","no")