Formula for cell=exact(left...&2)
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
"nastech" wrote:
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.
|