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...

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...

Sweet. Thanks. Never seen that EVAL function before....

=eval() isn't built into excel.

I'm guessing that Toppers has an addin that does this evaluation.

One version of a UDF that does that evaluation:

Option Explicit
Function Eval(myStr As String) As Variant
Eval = Application.Evaluate(myStr)
End Function

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm



SteveC wrote:

Sweet. Thanks. Never seen that EVAL function before....

--

Dave Peterson

thanks Dave... Maybe "EVAL" is native to Excel 2003? it's what I'm using...

I use xl2003, too.

Can you find it in xl2003's help?

If you type
=eval(
and click on the Fx button (to the left of the formula bar), what do you get?



SteveC wrote:

thanks Dave... Maybe "EVAL" is native to Excel 2003? it's what I'm using...

--

Dave Peterson

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

Sweet. Thanks. Never seen that EVAL function before....

If I try using EVAL, Excel 2003 gives a #NAME? error report in the cell.

I do have the Analysis Tool-pack add-in activated.

It's part of an add-in called Morefunc by Laurent Longre

http://xcell05.free.fr/english/

it's extremely useful, more info here

http://www.rhdatasolutions.com/morefunc/



--

Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
"It is a good thing to follow the first law of holes;
if you are in one stop digging." Lord Healey


"MyVeryOwnSelf" wrote in message
...
=IF(EVAL(CONCATENATE(A1,B1)),"yes","no")

Sweet. Thanks. Never seen that EVAL function before....

If I try using EVAL, Excel 2003 gives a #NAME? error report in the cell.

I do have the Analysis Tool-pack add-in activated.

try adding the UDF that Dave Peterson mentioned to a module within the
workbook you are using... that fixed a similar problem I had...


"MyVeryOwnSelf" wrote:

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

Sweet. Thanks. Never seen that EVAL function before....

If I try using EVAL, Excel 2003 gives a #NAME? error report in the cell.

I do have the Analysis Tool-pack add-in activated.