G
Guest
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?
=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?