S
Sebastien
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?
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?