I have a cell we will say A1, I have input the age range of 25-31 (this indicates an age bracket). If I input someone’s age at say “27” excel is not finding it in that Cell. I am struggling to find a way to define cell age 1 as containing each number in the spectrum from 25-31. Excel returns the data as if the person is 25 and not 27.
I hope this is enough info and not confusing, any help is greatly appreciated.