Jump to content

Calculate New Column... If Or Return Integer

John Powers

Recommended Posts


I am trying to make a new calculated [Column2] by searching for "Text1" or "Text2" in [Column1] and if either "Text1" or "Text2" is found, then return me an integer 1



If([Column1] = "Text1" or [Column1] = "Text2", 1)




So, obviously it doesn't work... please kindly help. I am not well-versed in the logic language here.


Thanks in advance,


Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Create New...