if statement for 2 conditions.

[dmxmikey]

I have this script

if([con-type]='2',[sell-price]-[discount],"sell-price"-"discount") as [sell-price-new]

and would like to add another condition , if operator='10' and [con-type]='2', then calculate as bove

[sunny_talwar · Accepted solution]

May be this

If([con-type] = 2 and operator = 10, [sell-price]-[discount], "sell-price"-"discount") as [sell-price-new]