If or statement

[bflan0524]

hello, i am trying to do an IF OR statement for a sheet that looks like this

[TABLE="width: 500"]
<tbody>[TR]
[TD]Column A[/TD]
[/TR]
[TR]
[TD]Other Non BAU Event-Use Comments[/TD]
[/TR]
[TR]
[TD]Other-Use Comment Box[/TD]
[/TR]
</tbody>[/TABLE]

so i want it to return a 1 if the fields say either of those items

i tried this but it didnt work:
=IF(OR($A2="Other Non BAU Event-Use Comments","Other-Use Comment Box",1""))

what am i doing wrong?

 

[AlanY]

=IF(OR($A2="Other Non BAU Event-Use Comments",$A2="Other-Use Comment Box"),1,"")

 

[bflan0524]

=IF(OR($A2="Other Non BAU Event-Use Comments",$A2="Other-Use Comment Box"),1,"")

perfect, ty

 

[AlanY]

you're welcome