Working Out: Working Age (18yr - upwards & Old Age Pensioner (65yr - upwards years)

[Leicester City Fox]

Hello There

I am looking for the simplest and shortest formula that will give " Working Age" (18yrs-aove) or " Old Age Pensioner Age" (65yrs Above) in a Colum.

I already have Colum which states their age to workout if they are 18 or 65 years above.

I am looking for the simplest shorts formula, as the one given is very longwinded one.

Thanks

Leicester City Fox

 

[Tucker92]

If(A1=>65,"OAP",If(A1=>18,"Working Age",If(A1<18,"","")))
A1 is the column that the age is in

 

[Leicester City Fox]

Hi Tucker92

Good Afternoon

I am very Grateful for this

Many Thanks

Leicester City Fox

 

[Eric W]

This also works:

=LOOKUP(A1,{0,18,65},{"","Working Age","OAP"})

 

[Leicester City Fox]

Hi Eric

Thanks this is a useful way of tackling the issue as well :

Many Thanks

Leicester City Fox