Hello Excel Community,

I am creating a worksheet and having trouble with a formula which I need the
excel to display the actual value for me.

Here is the i.e. if (line 5 or line 15, whichever is MORE)

A1 = 20 (@ line 5)
A2 = 34 (@ line 15)
B2 = ?

I am using this formula: =IF(a1<=V2, "More","Less")
But I need the actual value showing in B2.

Please help me.

Thank you.
Kenny