Forum Discussion
Stephen_Pisano
Dec 19, 2021Copper Contributor
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 ...
- Dec 19, 2021
HansVogelaar
Dec 19, 2021MVP
Stephen_Pisano
Dec 19, 2021Copper Contributor
HansVogelaar That is simply genius! So obvious when you have been given the answer! Thank You Hans and have a good Christmas!! Steve
- HansVogelaarDec 19, 2021MVP
Thank you for your kind words, and the same to you!