Multiple Case When statement

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'


Best Answer

  • GrantSmith
    GrantSmith Indiana 🔴
    edited November 10 Accepted Answer


    Try this:

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