Does anyone know how to seach for a numeric value in a cell and if found convert it to a specific text value
For example:
Cell A:1 could have a numeric value between 1 and 5. I want Cell A:2 to read the numeric value and convert it to a text format: if 1 then GO, if 2, then STOP, if 3 then PAUSE, if 4 then RUN, if 5 then JUMP.
For example:
Cell A:1 could have a numeric value between 1 and 5. I want Cell A:2 to read the numeric value and convert it to a text format: if 1 then GO, if 2, then STOP, if 3 then PAUSE, if 4 then RUN, if 5 then JUMP.