hello, i am trying to do an IF OR statement for a sheet that looks like this
<tbody>
Column A
Other Non BAU Event-Use Comments
Other-Use Comment Box
</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...