Either of 4 cells equals a value then get the desired result

[hsandeep]

How to formulate:

IF EITHER of B2 or D2 or F2 or G2 is EQUAL TO 1 THEN I2=100 ELSE “”

I am using Excel 2007.
Sheet1

	B	C	D	E	F	G	H	I
2	1		1		1	1		100

<colgroup><col style="FONT-WEIGHT: bold; WIDTH: 30px"><col style="WIDTH: 33px"><col style="WIDTH: 33px"><col style="WIDTH: 33px"><col style="WIDTH: 33px"><col style="WIDTH: 33px"><col style="WIDTH: 33px"><col style="WIDTH: 64px"><col style="WIDTH: 64px"></colgroup><tbody>
</tbody>

 

[stumac]

If C2 & E2 never contain 1 then you could use countif, if they can then use OR.

=IF(OR(B2=1,D2=1,F2=1,G2=1),100,"")

 

[hsandeep]

If C2 & E2 never contain 1 then you could use countif, if they can then use OR.

=IF(OR(B2=1,D2=1,F2=1,G2=1),100,"")

Thanks stumac. IT WORKS