Hi Bob,
It didn't seem to work.

my problem is this:

someone born in year "1972", I need an if statement to calculate that this
would be someone between "30-39"

Unless I was suppose to substitute something the the formula that you gave
me. If so please talk me through it...I'm kinda new at these "if statement".

Thank you
Sue

"Bob Phillips" wrote:

=CHOOSE(INT(I4/10),"","20-29","30-39","40-49","50-59","60-69")

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Sue" wrote in message
...
I need to flag ee who are between the ages of 20-29, 30-39, 40-49, 50-59,
and
60-69

what would the formual look like just using years eg born between 1976 and
1967 etc...

Thank you
hopeless