Multiple If conditions with left condition

F600314

Hi All,

I am trying to get "Loans" as output by applying following formula :

IF [Category Code (Segment Only)] = 2000 and [Category Code (Category Only)] = 40 and [Category Code (Sector Only)] = "50" and Left([Security Number (Full)],2="LX" then "Loans"

I am unable to get the desired output by applying above.

Appreciate your help

Thanks

Vishal

fmvizcaino

Hi @F600314 ,

You are missing the last part of the IF function.

IF [Category Code (Segment Only)] = 2000 and [Category Code (Category Only)] = 40 and [Category Code (Sector Only)] = "50" and Left([Security Number (Full)],2="LX" then "Loans"

Else 'anything else'

Endif