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...
Do you mean to calculate group # like
=MOD(A1-1,4)+1
?
- Basically, is there an easier and quicker way to do this:
=IFS(G10 =1, 1, G10= 2,1, G10 =3,1, G10 =4,1, G10 =5,2, G10 =6,2, G10 =7,2, G10 =8,2, G10 =9,3, G10 =10,3, G10 =11,3, G10 =12,3, G10 =13,4, G10 =14,4, G10 =15,4, G10 =16,4, G10 =-1, 5, G10= -2,5, G10 =-3,5, G10 =-4,5, G10 =-5,6, G10 =-6,6, G10 =-7,6, G10 =-8,6, G10 =-9,7, G10 =-10,7, G10 =-11,7, G10 =-12,7, G10 =-13,8, G10 =-14,8, G10 =-15,8, G10 =-16,8)That could be
=ABS(ROUNDUP(G10/4,0))+4*(G10<0)
- Yeah... I've just gone ahead and used an absurdly long IFS command
Seems to work... good luck to any slower computer that attempts to run it though!
Thanks for your help!
- 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 onThat's exactly what above formula do, assuming in column A are integers. Please check attached file
