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

<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>
[TD="bgcolor: #cacaca, align: center"]2[/TD]
[TD="align: right"]1[/TD]

[TD="align: right"]1[/TD]

[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]

[TD="bgcolor: #ffff00, align: right"]100[/TD]

</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