Trouble with If comparison

[SedonaBob]

An If statement in column AA asks whether entry in col B is >= "L2" and gets
a 'FALSE" result even though the entry in col B is "L12"? What am I doing
wrong?

Thanks.

 

[Peo Sjoblom]

In what way is L12 greater than L2?

--


Regards,


Peo Sjoblom

 

[SedonaBob]

L12 is greater than L2, but the IF statement returns a "FALSE" comparison
when I ask if L12 is greater than or equal to L2.

 

[Peo Sjoblom]

If are you talking about cells L2 and L12 then you should remove the
quotations

=L2

--


Regards,


Peo Sjoblom