This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Hi expert
Need your input
use a formula to define age in column E
>=80 is old,>=60 to <=79 is retired,>=35 to <=59 is middle,<=34 ,is youth
thz
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Answer accepted by question author
Hi,
And another from one who didn't miss the 'Old' category<g>
=LOOKUP(E1,{0,35,60,80},{"Youth","Middle","Retired","Old"})
Answer accepted by question author
Well done, Old-timer!
I can never get the right numbers in LOOKUP
Hurray - we can now edit our replies once more
best wishes
B
=IF(E1<=34,"Youth",IF(E1<=59,"Middle",IF(E1<=79,"Retired","Old")))
From one who missed OLD by a few years
best wishes