is there anyone who can help me out ?
I have a weight loss spreadsheet that I have developed to help me loose weight, would like it to give a text result based on a number range.
Example
if the range is 30+ in one cell a1 then the text result in a2 would be "obese"
if the range is between 25 to 29.9 in a1 then the result in a2 would be "overweight"
if the range is between 18.5 to 24.9 in a1 then the result in a2 would be "Healthy"
for the life of me, I can not figure out how to do it.
Thanks in advance.
- - - Updated - - -
Never mind figured it