If statement for this excel formula

Question

If statement for the below in formula tool ?

=IF(L8="","No Trade ID",IF(OR(D8="BOND (INFLATION)",D8="CDS",D8="BondFuture"),L8,IF(OR(J8="1379-EUBND",J8="1380-EUBND",J8="4039-FWDCB",J8="4039-FWDSL"),L8&J8,IF(AND(D8="Bond",OR(E8="Local",E8="Supranational")),L8,B8))))

apathetichell · Answer

Kind of impossible without more data - but basically an exact reformat would be:

if [L] ="" then "No Trade" elseif [D] in ("Bond (Inflation)","CDS","BondFuture") then [L] elseif [J] in ("1379-EUBND","1380-EUBND","4039-FWDCB","4039-FWDSL) then [I]+[J] elseif [D] ="Bond" and [E] in("Local","Supranational") then [L] else [B] endif

That assumes that each column is a) a string and b) labeled as the old excel column name.

clmc9601 · Answer

Hi @HafeezA,

Try this:

IF IsEmpty([col_L])

THEN "No Trade ID"

ELSEIF [col_D] IN ('BOND (INFLATION)', 'CDS', 'BondFuture')

THEN [col_L]

ELSEIF [col_J] IN ("1379-EUBND","1380-EUBND","4039-FWDCB","4039-FWDSL")

THEN [col_L]+[col_J]

ELSEIF [col_D] = 'Bond' and ([col_E] IN ('Local', 'Supranational')

THEN [col_L]

ELSE [col_B]

ENDIF

If this helps, please consider marking it a solution so others may find it.