Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Multiple Values using if-- inlist

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 Member
Former Member replied


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

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question