Requirement on if condition

[#1]

Hi guys

i have implemented this if condition but it showing error.could you please help me out on this

if(Product='Two Wheelers' and Level='Level1','Test3',

  if(Product='Three Wheelers' and Level='Level1','Test4,

  if(item='gear' and id=2 ,'Test1',

  if(item5='clach' and pid=7, 'Test2')))) as New_Skill,

Thanks,

Siddik

[trdandamudi]

What is the error you are getting ? Can post it here please.

[Clever_Anjos]

You are missing a ' after Test4

[Chanty4u]

try this

if(Product='Two Wheelers' and Level='Level1','Test3',

  if(Product='Three Wheelers' and Level='Level1','Test4',

  if(item='gear' and id=2 ,'Test1',

  if(item5='clach' and pid=7, 'Test2')))) as New_Skill,