hello, i am trying to do an IF OR statement for a sheet that looks like this
<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?
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?