andyk1010Copper ContributorNov 25, 2022SolvedGrouping Value Input Hi, I have a list customers who are in different age groups. The age groups are <25, 26-35, 36-45, 46-55 and >55 If the customer falls into the age group a Y appears, if not the cell is blank. ...Show MoreHarun24HRNov 25, 2022andyk1010 Use IFS() function=IFS(A2<=25,"<25 Y",AND(A2>=26,A2<=35),"26-35 Y",AND(A2>=36,A2<45),"36-45 Y",AND(A2>46,A2<=55),"46-55 Y",A2>55,">55 Y") IFS.xlsx10 KB
Harun24HRNov 25, 2022andyk1010 Use IFS() function=IFS(A2<=25,"<25 Y",AND(A2>=26,A2<=35),"26-35 Y",AND(A2>=36,A2<45),"36-45 Y",AND(A2>46,A2<=55),"46-55 Y",A2>55,">55 Y") IFS.xlsx10 KB
Harun24HRNov 25, 2022andyk1010 Use IFS() function=IFS(A2<=25,"<25 Y",AND(A2>=26,A2<=35),"26-35 Y",AND(A2>=36,A2<45),"36-45 Y",AND(A2>46,A2<=55),"46-55 Y",A2>55,">55 Y") IFS.xlsx10 KB
Harun24HRBronze ContributorNov 25, 2022andyk1010 Use IFS() function=IFS(A2<=25,"<25 Y",AND(A2>=26,A2<=35),"26-35 Y",AND(A2>=36,A2<45),"36-45 Y",AND(A2>46,A2<=55),"46-55 Y",A2>55,">55 Y") IFS.xlsx10 KB
