If statement with a not equals in it

[PowerBINoob12]

Hi All,

I've created a new column and im trying to add the below logic to it:

if "fruit" equals "Bananna" and "colour" does not equal "yellow" then "unripe"

I've tried both ways below but they dont work as it wont compare the string in both cases

IF([Fruit] = "Bananna" && NOT([Color]) = "Yellow", "Unripe",  

IF([Fruit] = "Bananna" && ([Colour]) <> "Yellow", "Unripe",  

All values are strings

Any help would be appreciated.

[ce87]

Hi @PowerBINoob12 ,

This can be accomplished with NOT and IN

NOT([Color]) IN { "Yellow", "Unripe" }), 

[PowerBINoob12]

I need both parts of the if statement though - It also needs to check if fruit = bananna

[ce87 · Accepted solution]

The start of your formula was already correct. The full formula would be;

IF([Fruit] = "Bananna" && NOT([Color]) IN { "Yellow", "Unripe" }),