(And) expression

[lmossolle]

I am trying to use this command i am getting an error;

SAT to 1M=IIF(AND([KT Value]>100000,{KT Value]<1000000),[KT Value],"")

 

[KARL DEWEY]

SAT to 1M: IIF([KT Value]>100000 AND [KT Value]<1000000, [KT Value],"")