3 Replies Latest reply: May 31, 2011 6:25 AM by Anne Duffy RSS

    if statement in script more than 3 conditions !?!!

      Hi Guys Yesterday I was helped put an If statement in the script, if( [Was backvaluation required ?] ='Yes'  and [Issue held with] = 'Cops Team','Yes','No') as  [Corp Ops Backvaluation] It works a charm !!! But today I need to amend it a little, I need to add in another and where [Type of Event] is not "Margin Change"  I have tried the following but getting an Error in expression: ')' expectedon load if( [Was backvaluation required ?] ='Yes'  and [Issue held with] = 'Cops Team' and [Type of Event] not 'Margin Change' ,'Yes','No') Pleeeeaaasseee Help Thanks Anne