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 ...
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.
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.