Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Can some one please help me writing this multiple if else statement
IF(Airport = 'N','Left',if(Type = 'A' AND [Race1] = 'FA',if(Race2 = 'RC' or 'RG','Right','Skip'))) as Type
Thanks!
Hope this helps.
IF(Airport = 'N', 'Left',
if((Type = 'A' AND [Race1] = 'FA'),
if((Race2 = 'RC' or Race2='RG'),'Right','Skip'))) as Type
Hope this helps.
IF(Airport = 'N', 'Left',
if((Type = 'A' AND [Race1] = 'FA'),
if((Race2 = 'RC' or Race2='RG'),'Right','Skip'))) as Type
Thank you! You rock!