Expression Error ')' expected

[20]

All brackets are closed in this string, not sure what is wrong here, continuing to get expression error ')' expected

=if((type='X' or type='Y') and Level2!='Z' and InsightSentiment<=X' and Score<='Y', Level3)

I want to display Level 3 if type is X or Y, sentiment and score are less than X and Y, and as long as Level 2 is not Z. 

Thanks 

[tresesco]

Error message always can't tell the exact issue. Most of the time it is indicative; you have to debug and find the real issue. Here it could be just a missing quote (in red below):

=if((type='X' or type='Y') and Level2!='Z' and InsightSentiment<='X' and Score<='Y', Level3)

[20]

Thank you for your response, unfortunately there is still an error 

[tresesco]

Check if there are spaces between the separate literals. Could you post a screenshot of the error (with the entire expression)?

[20]

Please see below! 

[er77]

I found the problem; try with this:

=if((type='X' or type='Y') and Level2<>'Z' and InsightSentiment<='X' and Score<='Y', Level3)

Please note you are missing ' before X' and not equal must be <> and not 1=

Let me know if works.

[er77]

try to replace != with <>

[20]

Great, thank you that works!!

[er77 · Accepted solution]

great! can you mark my answer as Solution to your question?