Trouble with If comparison
 

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.

Trouble with If comparison
 

In what way is L12 greater than L2?

--


Regards,


Peo Sjoblom



"SedonaBob" wrote in message
...
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.

Trouble with If comparison
 

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" wrote:

In what way is L12 greater than L2?

--


Regards,


Peo Sjoblom



"SedonaBob" wrote in message
...
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.

Trouble with If comparison
 

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

=L2


--


Regards,


Peo Sjoblom


"SedonaBob" wrote in message
...
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" wrote:

In what way is L12 greater than L2?

--


Regards,


Peo Sjoblom



"SedonaBob" wrote in message
...
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.