Hi, I'm working on a project and I was wondering if anyone can help me. I
need to know the formula that I can use to input the age of each individuals,
those who are "under 55", "age 55", and "over 55". I tried to input the
formula for all three but it said that I enter too many arguments. Any help
would be appreciated.

Hi there

Can you post your formula?

Peter

"Containsmiles" wrote:

Hi, I'm working on a project and I was wondering if anyone can help me. I
need to know the formula that I can use to input the age of each individuals,
those who are "under 55", "age 55", and "over 55". I tried to input the
formula for all three but it said that I enter too many arguments. Any help
would be appreciated.

You can use a nested if statement

=if(a1=55,"Age 55",if(a1<55,"Under 55","over 55"))

Or if you want an error condition you can nest another if statement:

=if(a1=55,"Age 55",if(a1<55,"Under 55",if(a155,"Over 55","Error")))

FYI you can nest 7 if statements I believe, and if you need more you
can reference another cell that uses more if statements


--
shadestreet
------------------------------------------------------------------------
shadestreet's Profile: http://www.excelforum.com/member.php...fo&userid=7092
View this thread: http://www.excelforum.com/showthread...hreadid=544894

You can easily calculate the age with

=DATEDIF(A1,TODAY(),"y")

what do you want to do then?

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"Containsmiles" wrote in message
...
Hi, I'm working on a project and I was wondering if anyone can help me. I
need to know the formula that I can use to input the age of each
individuals,
those who are "under 55", "age 55", and "over 55". I tried to input the
formula for all three but it said that I enter too many arguments. Any
help
would be appreciated.

I used the IF formula: =IF (A1....) but I'm lost. Is it possible to have
all three if's "under 55", "age 55", and "over 55" years of age?

"PDUK1" wrote:

Hi there

Can you post your formula?

Peter

"Containsmiles" wrote:

Hi, I'm working on a project and I was wondering if anyone can help me. I
need to know the formula that I can use to input the age of each individuals,
those who are "under 55", "age 55", and "over 55". I tried to input the
formula for all three but it said that I enter too many arguments. Any help
would be appreciated.

I tried the formula but it didn't work. My data has like about 600
individuals. I was trying to do three different column of their ages: (1)
based on their present age, (2) their age in 12/31/2007, and (3) their age in
6/30/2009.

"shadestreet" wrote:


You can use a nested if statement

=if(a1=55,"Age 55",if(a1<55,"Under 55","over 55"))

Or if you want an error condition you can nest another if statement:

=if(a1=55,"Age 55",if(a1<55,"Under 55",if(a155,"Over 55","Error")))

FYI you can nest 7 if statements I believe, and if you need more you
can reference another cell that uses more if statements


--
shadestreet
------------------------------------------------------------------------
shadestreet's Profile: http://www.excelforum.com/member.php...fo&userid=7092
View this thread: http://www.excelforum.com/showthread...hreadid=544894

I just played with the formula you gave and I got it. Thanks for your help.
=IF(I2=55,"Age 55",IF(I255,"over 55",IF(I2<55,"under 55")))

"shadestreet" wrote:


You can use a nested if statement

=if(a1=55,"Age 55",if(a1<55,"Under 55","over 55"))

Or if you want an error condition you can nest another if statement:

=if(a1=55,"Age 55",if(a1<55,"Under 55",if(a155,"Over 55","Error")))

FYI you can nest 7 if statements I believe, and if you need more you
can reference another cell that uses more if statements


--
shadestreet
------------------------------------------------------------------------
shadestreet's Profile: http://www.excelforum.com/member.php...fo&userid=7092
View this thread: http://www.excelforum.com/showthread...hreadid=544894

I solved it already. Thanks for your help. I used Datedif function before
but somehow it didn't apply to this scenario. Instead I used the following:
=IF(I2=55,"Age 55",IF(I255,"over 55",IF(I2<55,"under 55")))
Hey, looks like my Excel is improving thanks to the community board. Thanks
again.

"Bob Phillips" wrote:

You can easily calculate the age with

=DATEDIF(A1,TODAY(),"y")

what do you want to do then?

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"Containsmiles" wrote in message
...
Hi, I'm working on a project and I was wondering if anyone can help me. I
need to know the formula that I can use to input the age of each
individuals,
those who are "under 55", "age 55", and "over 55". I tried to input the
formula for all three but it said that I enter too many arguments. Any
help
would be appreciated.