If I have one cell with a number in it, how can I have the cell next to it refer to that cell. For example, if I record someones BMI (body mass index) as 22.5, can I automatically have the cell next to it refer to what this means using words, e.g. normal weight, underweight ect?
Solved by D. A. in 13 mins