Forum Discussion
IF function for Cell contain Range
Hello Everyone ! how to use IF function when a cell has values with range , see below. i want age group 30 to 32 then ok otherwise not okay.
GenderAge Group
| Male | 25-34 |
| Male | 35-49 |
| Male | 18-24 |
| Female | 50+ |
| Male | 25-34 |
| Female | 50+ |
| Male | 25-34 |
| Male | 35-49 |
| Male | 18-24 |
1 Reply
- I think the problem here is that Excel is not going to see these cells as numbers. I’m not aware of a way to make one cell hold a range in such a way that it will know “25-34” should report TRUE if tested for “32.”
I am following this thread because I’m now curious if this is possible. But I think you may need to find a work around that accomplishes what you want but requires a different setup.
