Forum Discussion
Solved
Wrong formula?
I don't know why it's wrong, I've deleted every space in I14:J16 but always #N/A.
4 Replies
- It worked, thanks :))), But why dash?
I assume that I14:I16 contain numeric values.
LEFT(B3,2) returns a text string such as "50".
Text strings don't match numbers.
The first minus sign converts the text string "50" to the number -50.
The second minus sign converts -50 to 50.
We could also have used 1*LEFT(B3,2) or 0+LEFT(B3,2). All of these force Excel to convert the text string to a number.
