:) sorry, didn't realize same replier... thanks

"Bob Phillips" wrote:

That is a double unary. The RIGHT function will return a string, so a single
unary will convert it to a number, but a negative number, so the second
reverts it back to positive.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"nastech" wrote in message
...
Hi, thanks, will give that a try, was wondering what the double negative /
2
minus signs do? thanks

"Bob Phillips" wrote:

Try this

=AND(EXACT(LEFT(T9),"x"),--RIGHT(T9,LEN(T9)-1)=$BJ$6/10)

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"nastech" wrote in message
...
trying to make an equation for conditional format...?? where same
cell
has
x2, need to test for Exact/ small "x",

is this close, can't quite get: (where bj6 is 20)
=T9=(EXACT(LEFT(T9,1),"x")&$BJ$6/10) comes up false for "x2",
should be
true.

=EXACT(LEFT(T9,1),"x")&$BJ$6/10 gets a true2

thanks.