Formula Multiple condition

Question

Hello,

Please help me with the formula.

Condition description

New column to be created with condition that Seccode1 should be equal to Sedol and if sedol is missing then Isin and also if Isin and Sedol both missing then Cusip.

Input Input Input Output Isin     Sedol     Cusip     Secode1US3140QKGB85 3140QKGB8US3140QKGB85SE0005676608BPXR9R2W77537SD6BPXR9R2BMG9156K1018BF5BLM1G9156K101BF5BLM1BMG9156K1018BF5BLM1G9156K101BF5BLM1AU0000157067BNNVRL0Q9269W108BNNVRL0  901384107901384107KYG8875G1029BY9D3L9G8875G102BY9D3L9  U81522AG6U81522AG6

SPetrie · Accepted Answer

An if elseif should work

if !IsEmpty([Sedol]) then [Sedol] elseif !IsEmpty([Isin])then [Isin] else [Cusip] endif

martinding · Accepted Answer

Hi @Devika,

The formula @SPetrie provided is perfect!

To help you understand how IF-ELSEIF-ELSE works, I've provided another example, where all the conditions are positive (e.g. no "!"/not).

Note, the ordering is very important.

The statements are evaluated from top to bottom. So for example, if we wrote

"IF ISEMPTY([Sedol]) THEN [Isin] " first, then it will give a different result.