If or statement

[bflan0524]

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

Column A

Other Non BAU Event-Use Comments

Other-Use Comment Box

<tbody>
</tbody>

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