View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
nastech
 
Posts: n/a
Default Formula for cell=exact(left...&2)

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.