Expression - Alternative of If Statement

[#1]

Hi Experts,

I would like to check one thing for Expression.

I have below condition and i need to put and mimic below conditions in Expression.

=If(Column A > Column B, 'New York', 'Boston')

we can put and mimic above condition in Expression using If Statement.

Bur, I do not want to using IF Statement.

so, do we have any alternative of IF Statement for Expression ?

can someone provide example ?

Thanks for your time and help on this.

[sunny_talwar]

What is your data in Columns [Column A] and [Column B]? Share some more information so that you can get quick help.

[#3]

Thanks Sunny.

Both columns has data in numbers.

Column A - Data - 53

Column B - Data - 150

Let me know, if you need more information.

[sunny_talwar]

So you are trying to compare Column A vs. Column B and you don't want to use if statement? May I ask why? May be there is another way to do this, but from what I am seeing, it doesn't seem possible to me.

[roger_stone]

Have you looked at the MATCH function?