| 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 |
| 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 | |||
Threaded Mode
