Help with Excel Formulas or Functions

[Containsmiles]

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.

[PDUK1]

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.
>
>

[shadestreet]

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(a1>55,"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

[PDUK1]

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.
>
>

[Bob Phillips]

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" <[email protected]> wrote in message
news:[email protected]...
> 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.
>
>

[Containsmiles]

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.
> >
> >

[Containsmiles]

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(a1>55,"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
>
>

[Containsmiles]

I just played with the formula you gave and I got it. Thanks for your help.
=IF(I2=55,"Age 55",IF(I2>55,"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(a1>55,"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
>
>

[Containsmiles]

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(I2>55,"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" <[email protected]> wrote in message
> news:[email protected]...
> > 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.
> >
> >
>
>
>