IS AND OR

Detrie Zacharias

=IF(AND((([Asset Type]113 = "Success Story"), OR([Asset Type]113 = "Video - Client")), Ancestor113 = "2"), "1")

Trying to populate "1" where Asset type = Success Story OR Video - Client AND Ancestor = 2

THis throws an UNPARSABLE error. I think it may be related to my parenthesis

Paul Newcome

The OR is in the wrong spot.

Try this...

=IF(AND(OR([Asset Type]113 = "Success Story", [Asset Type]113 = "Video - Client"), Ancestor113 = "2"), "1")

If you are planning on using that 1 as a numerical value though, you will also want to remove the quotes from around it. The quotes turn it into text.

Amit Wadhwani

Jayesh Nathani

Hi Stavros,

You are right, it's your parenthesis, I have corrected it:

=IF(AND([Asset Type]113 = "Success Story", OR([Asset Type]113 = "Video - Client", Ancestor113 = "2")), "1")

Detrie Zacharias

Thanks Jayesh... I really need to work on my use of parenthesis

Detrie Zacharias

Hmm.. Actually it is getting Success Story but not picking up Video - Client

Paul Newcome

The OR is in the wrong spot.

Try this...

=IF(AND(OR([Asset Type]113 = "Success Story", [Asset Type]113 = "Video - Client"), Ancestor113 = "2"), "1")

If you are planning on using that 1 as a numerical value though, you will also want to remove the quotes from around it. The quotes turn it into text.

Detrie Zacharias

Thanks all for your help...

Paul Newcome

Happy to help! 👍️