Try:

=IF(EVAL(CONCATENATE(A1,B1)),"yes","no")

"SteveC" wrote:

Col A Col B Col C
0.51 <.50 No

Col A contains a formula that returns a value.

Col B is data hard coded. (I juse this to help with advanced filter)

Col C --- trying to get a formula that would return a logic test... If A
is less than the value shown in B, then Yes, otherwise No.

I'd like to use conacatentate to incorporate the hard coded value in Col B,
because I use this Col as a reference for filtering. Any ideas? Thanks...