Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
if([Comparison Contract]>[MKT3], "EXPENSIVE",
if([Comparison Contract]<[MKT1], "CHEAPEST",
"-"
))
Try this:
if(ComparisonContract > MKT3,
"Expensive",
if(ComparisonContract < MKT1,
"Cheapest",
"-"
)
)