Nested if

balrammahato204 — Thu, 29 Oct 2015 20:00:12 GMT

Hi all

Please help me

i have 4 condition and i am not able to put my condition in If condition

could you please help me

please find the scaniario

CASE #1: If BA_TEST_CODE = 'SY', and Stamp code>=9000 and Stamp code<=9999
then 'LYMP else 'LYDP'.

CASE #2: If BA_TEST_CODE = 'IL' then set as 'ILA'

CASE #3: If BA_TEST_CODE = 'PS' then set as 'LRA'

CASE #4: BA_TEST_CODE IS NOT ('SY', 'IL', 'PS') then set as 'POOL'

Re: Nested if

MK_QSL — Thu, 29 Oct 2015 20:54:37 GMT

IF(BA_TEST_CODE = 'IL', 'ILA',

IF(BA_TEST_CODE = 'PS', 'LRA',

IF(BA_TEST_CODE = 'SY' and Stamp_Code >= 9000 and Stamp_Code <= 9999, 'LYMP',

IF(BA_TEST_CODE = 'SY' and (Stamp_Code < 9000 or Stamp_Code > 9999), 'LYPD',

IF(Not Match(BA_TEST_CODE,'IL','PS','SY'),'POOL')))))