Using OR in a formula

aecross

Hi there -

My goal is to have a formula that notes if Bayside Conversion is Completed or Completed - Not Implemented, then enter 5 into cell, otherwise enter 0.

Here is my current formula, I am getting "UNPARSEABLE"

=IF([BAYSIDE CONVERSION]@row = "COMPLETED", OR(@row = "COMPLETED - NOT IMPLEMENTED", 5, 0))

Thanks!

Nick Korna

Hi @aecross,

The formula you would need is:

=IF(OR([Bayside Conversion]@row = "Completed", [Bayside Conversion]@row = "Completed - Not Implemented"), 5, 0)

Hope this helps; if you've any questions etc. then just post! 😊

Ipshita

Hello @aecross Here is your answer -

Instead of Status, enter your Bayside Conversion :)

=IF(OR(Status@row = "Completed", Status@row = "Completed - Not Implemented"), 5, 0)

Hope this helps!

Cheers!

Ipshita

aecross

That worked! Thank you, Nick!