Multiple Case When statement

Emma

Hi - I'm looking for a Case statement that will provide a new column when 2 columns meet a particular condition.

I've tried multiple versions but none have worked. 2 examples below. Thanks in advance for any suggested fixes to the formula.

IF(AND(`Plant`=1302,`Line of Business`='cable'),'QC Fibre','')

WHEN(`Plant`=1302 AND `Line of Business`='Cable')

THEN 'QC Fibre'

END

GrantSmith

@Emma

Try this:

CASE WHEN `Plant`=1302 AND `Line of Business`='Cable' THEN 'QC Fibre' END

GrantSmith

@Emma

Try this:

CASE WHEN `Plant`=1302 AND `Line of Business`='Cable' THEN 'QC Fibre' END

Emma

Thank you Thank you @GrantSmith It worked beautifully.