| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Compare the value of 2 cells and get Flase/true statement
Good day,
This is the situation: Cell A1 = Fd39(07) Cell A2 = 39 Cell A3 =TRIM(MID(A1, 3, 2)) Cell A4 = A2 = A3 As you can see from above, the result of the formula in Cell A3 is 39. However, Cell A4 always gives me a FALSE statement. I would need to return a TRUE statement in Cell A4, because it is comparing two values that should be identical (39 & 39, right?). How can I extract the "39" from the "Fd39(07)" expression and compare is succesfully to the number 39 in Cell A4? -- Thanks Sebastien |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Compare the value of 2 cells and get Flase/true statement
In A3
=--TRIM((MID(A1,3,2))) all text functions like MID etc will return a text value, the -- will force it into a number -- Regards, Peo Sjoblom "Sebastien" wrote in message ... Good day, This is the situation: Cell A1 = Fd39(07) Cell A2 = 39 Cell A3 =TRIM(MID(A1, 3, 2)) Cell A4 = A2 = A3 As you can see from above, the result of the formula in Cell A3 is 39. However, Cell A4 always gives me a FALSE statement. I would need to return a TRUE statement in Cell A4, because it is comparing two values that should be identical (39 & 39, right?). How can I extract the "39" from the "Fd39(07)" expression and compare is succesfully to the number 39 in Cell A4? -- Thanks Sebastien |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Compare the value of 2 cells and get Flase/true statement
Cell A4 =A2=VALUE(A3)
or Cell A4 =A2=A3+0 or Cell A4 =A2=A3*1 -- Wigi http://www.wimgielis.be = Excel/VBA, soccer and music "Sebastien" wrote: Good day, This is the situation: Cell A1 = Fd39(07) Cell A2 = 39 Cell A3 =TRIM(MID(A1, 3, 2)) Cell A4 = A2 = A3 As you can see from above, the result of the formula in Cell A3 is 39. However, Cell A4 always gives me a FALSE statement. I would need to return a TRUE statement in Cell A4, because it is comparing two values that should be identical (39 & 39, right?). How can I extract the "39" from the "Fd39(07)" expression and compare is succesfully to the number 39 in Cell A4? -- Thanks Sebastien |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Compare the value of 2 cells and get Flase/true statement
Thanks Wigi and Peo Sjoblom for the help
-- Thanks Sebastien "Wigi" wrote: Cell A4 =A2=VALUE(A3) or Cell A4 =A2=A3+0 or Cell A4 =A2=A3*1 -- Wigi http://www.wimgielis.be = Excel/VBA, soccer and music "Sebastien" wrote: Good day, This is the situation: Cell A1 = Fd39(07) Cell A2 = 39 Cell A3 =TRIM(MID(A1, 3, 2)) Cell A4 = A2 = A3 As you can see from above, the result of the formula in Cell A3 is 39. However, Cell A4 always gives me a FALSE statement. I would need to return a TRUE statement in Cell A4, because it is comparing two values that should be identical (39 & 39, right?). How can I extract the "39" from the "Fd39(07)" expression and compare is succesfully to the number 39 in Cell A4? -- Thanks Sebastien |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| compare data / MATCH(TRUE.. ROW.. | Excel Discussion (Misc queries) | |||
| Two TRUE to one FALSE statement | Excel Worksheet Functions | |||
| If Statement returns true when false? | Excel Discussion (Misc queries) | |||
| ISBLANK returns flase when there is nothing in the cell referenced | Excel Discussion (Misc queries) | |||
| Compare 2 cells values with one IF statement | Excel Worksheet Functions | |||
Linear Mode
