Try this:

=AND(COUNT(K$1,B2)=2,IF(K$2="",B2K$1,IF(K$2="<", B2<K$1)))

--
Biff
Microsoft Excel MVP


"dlamarche" <Melbourne wrote in message
...
Hello I know that I can do a formula like:

$B2$K$1 in the formula box to apply a DF all cells in column B where the
value is higher than the value in K1. Good. Now what I was asked to do is
to
put the comparison operator in a cell ... as well!

This way the user can change the number in K1 but the conditional operator
too which, say, is in K2. So K1 contains 3500 and K2 contains and I want
to
do a formula in the CF formula box. The user can change the value in K1
and
type or < in K2 and the CF will update.

It is interesting that in any cell I can to a simple concatenation like
"="&$B2&$K$2&$K$1 and pressing Enter displays

=45006000

I have played with indirect a bit to create a reference in a
concatenation.
It seems that CF can only accept a real formula and not a one built as the
result of an expression.

Any idea? Thank you.
--
Daniel