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

[#1]

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

[#2]

*** DONT KNOW WHAT HAPPENED FORMAT ABOVE ***

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

[pat_agen · Accepted solution]

hi,

change

     not 'Margin Change' "

to

     <> 'Margin Change' 

that should do the trick.

[#4]

Thanks Pat , just realised that!

All working good now

Thanks