How to put if expression?

[siva_boggarapu]

Hello There,

How to write If condition in below condition

IF Comparison Contract > MKT3, “EXPENSIVE”. IF Comparison Contract < MKT1, “CHEAPEST”. If none of the previous, “-“

Thanks,

Siva

[#2]

if([Comparison Contract]>[MKT3], "EXPENSIVE",

if([Comparison Contract]<[MKT1], "CHEAPEST",

"-"

))

[mphekin12]

Try this:

if(ComparisonContract > MKT3,

"Expensive",

if(ComparisonContract < MKT1,

  "Cheapest",

  "-"

)

)