Multiple Values using if-- inlist

[Former Member]

Hi,

How to pass multiple values  using inlist and if

=if([Plant] InList("2010";"2012";"2014";"2016";"2018") ; xyz") ElseIf([Plant] InList("2020";"2022";"2024";"2026";"2028"); "pqr") ElseIf

([Plant] InList("2030";"2032";"2034");"abc") else ([dgh])

i am getting error in this please correct it

Thanks & Regards,

Vinay

[former_member203850 · Accepted solution]

Use  "Then " to resolve above error.

For example :

=If([Year]InList("2001";"2002";"2003")) Then "Y" ElseIf ([Year]InList("2005";"2006";"2007")) Then "yy" Else ([Year])

Regards,

Pranay

[Former Member · Accepted solution]

Thanks Pranay its working Done some small Correction

Thanks & Regards

Vinay