Creating a new colum based on the Staus of two other columns

[alawode]

Hi Experts,

I have two Columns 'Chemical' and 'Type'. I am tryinf to create a new column called 'Not Liquid' which will specify if that anytime sulphur and Calcium come in to the table as liquid, the new colum should show "Not Liquid" in the 'Not Liquid' column as shown in the table attached.

Thanks in advance

[Greg_Deckler · Accepted solution]

I believe this should be:

if ([Chemical] = "Sulphur" or [Chemical] = "Calcium") and [Type] = "liquid" then "Not Liquid" else null

[alawode]

@Greg_DecklerThanks, this worked!