This requires too many IFs....
On spectrum we had X=LEFT(Y,Z)....
This requires too many IFs....
On spectrum we had X=LEFT(Y,Z)....
You are mixing string with numeric values...
12345 is a decimal number.
LEN or any other similar command (LEFT, RIGHT, MID) will take as an input just string characters, not numeric values.
Ioannis
Look up DIG. It isolates single digit, as you need it, without IF...
Bookmarks