Forum Discussion
How to return multiple results based on multiple criteria
I have 8 groups that i need to place individual entries into. The individual entries return as numbers between 1 and 16. 1-4 need to go into group 1 4-8 need to go into group 2 and so on I.E...
No, I mean....
If the number in cell A is between 1 & 4, I want cell B to return 1
If the number in cell A is between 5& 8, cell B returns 2
and so on
If the number in cell A is between 1 & 4, I want cell B to return 1
If the number in cell A is between 5& 8, cell B returns 2
and so on
That's exactly what above formula do, assuming in column A are integers. Please check attached file