Formula for cell=exact(left...&2)

[Guest]

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.

 

[Guest]

Since =(EXACT(LEFT(T9,1),"x")&$BJ$6/10) returns true2 and T9 = x2,
=T9=(EXACT(LEFT(T9,1),"x")&$BJ$6/10) must return false beacuse the 2 values
are not equal.

If you you just want to check on the small "x" you must use :
=EXACT(LEFT(T9,1),"x")

If you want to check the concatenation of "x"& BJ6/10 then use

=EXACT(T9;"x"&$BJ$6/10)

HTH

Hans

 

[Bob Phillips]

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)

 

[macropod]

Hi nastech,

Perhaps
=EXACT(LEFT(T9),"x")*$BJ$6/10>0

Cheers

 

[Guest]

Hi, thanks, will give that a try, was wondering what the double negative / 2
minus signs do? thanks

 

[Bob Phillips]

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)

 

[Guest]

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

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)