Forum Discussion
lpea60
Oct 14, 2021Copper Contributor
IFS function not returning a result
I am an Office 365 subscriber and I am using Excel version 2109 build 14430.20298. I am new to the IFS function but it has worked in the same spreadsheet in other formulas. But in this one, I h...
OliverScheurich
Oct 14, 2021Gold Contributor
=IFS(AND(L2>14,L2<25),"15-24 years",
AND(L2>24,L2<35),"25-34 years",
AND(L2>34,L2<45),"35-44 years",
AND(L2>44,L2<55),"45-54 years",
AND(L2>54,L2<65),"55-64 years",
L2>64,"65+ years")
This formula returns the values for the different ages.