Forum Discussion

Stephen_Pisano's avatar
Stephen_Pisano
Copper Contributor
Dec 19, 2021
Solved

Creating an IF formula to convert a range of numbers from an adjacent column

I am using 16.56 Excel. I am trying to convert a column of numbers that range from 1 to 4. I want to be able to write an IF formula that can reverse convert the numbers into a new column. So column ...
Formulas and Functions
  • Stephen_Pisano's avatar
    Stephen_Pisano
    Copper Contributor
    Dec 19, 2021

    HansVogelaar   That is simply genius! So obvious when you have been given the answer!  Thank You Hans and have a good Christmas!! Steve

Resources