Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula for cell=exact(left...&2)
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. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula for cell=exact(left...&2)
Hi nastech,
Perhaps =EXACT(LEFT(T9),"x")*$BJ$6/100 Cheers -- macropod [MVP - Microsoft Word] "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. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula for cell=exact(left...&2)
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. |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula for cell=exact(left...&2)
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. |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula for cell=exact(left...&2)
:) 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Match then lookup | Excel Worksheet Functions | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Creating a check mark box | Setting up and Configuration of Excel | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) |