Change number to text formula

Try...

=LOOKUP(A1,{50,60,70},{"A","B","C"})

....where A1 contains the person's age.

Hope this helps!

In article <[email protected]>,
"Fesk" <[email protected]> wrote:

> Hi
> I would like to be able to type in persons age and have excel place it into
> a category.
>
> eg
> 50 to 59 would be in the 'A' category
> 60 to 65 would be in the 'B' category
> 70 and over would be in the 'c' category
>
> Hope you can make sense of this. Any help would be appreciated.
> Thanks
> Fesk

Try...

=LOOKUP(A1,{50,60,70},{"A","B","C"})

....where A1 contains the person's age.

Hope this helps!

In article <[email protected]>,
"Fesk" <[email protected]> wrote:

> Hi
> I would like to be able to type in persons age and have excel place it into
> a category.
>
> eg
> 50 to 59 would be in the 'A' category
> 60 to 65 would be in the 'B' category
> 70 and over would be in the 'c' category
>
> Hope you can make sense of this. Any help would be appreciated.
> Thanks
> Fesk

Try...

=LOOKUP(A1,{50,60,70},{"A","B","C"})

....where A1 contains the person's age.

Hope this helps!

In article <[email protected]>,
"Fesk" <[email protected]> wrote:

> Hi
> I would like to be able to type in persons age and have excel place it into
> a category.
>
> eg
> 50 to 59 would be in the 'A' category
> 60 to 65 would be in the 'B' category
> 70 and over would be in the 'c' category
>
> Hope you can make sense of this. Any help would be appreciated.
> Thanks
> Fesk

Try...

=LOOKUP(A1,{50,60,70},{"A","B","C"})

....where A1 contains the person's age.

Hope this helps!

In article <[email protected]>,
"Fesk" <[email protected]> wrote:

> Hi
> I would like to be able to type in persons age and have excel place it into
> a category.
>
> eg
> 50 to 59 would be in the 'A' category
> 60 to 65 would be in the 'B' category
> 70 and over would be in the 'c' category
>
> Hope you can make sense of this. Any help would be appreciated.
> Thanks
> Fesk

Hi
I would like to be able to type in persons age and have excel place it into
a category.

eg
50 to 59 would be in the 'A' category
60 to 65 would be in the 'B' category
70 and over would be in the 'c' category

Hope you can make sense of this. Any help would be appreciated.
Thanks
Fesk

Try...

=LOOKUP(A1,{50,60,70},{"A","B","C"})

....where A1 contains the person's age.

Hope this helps!

In article <[email protected]>,
"Fesk" <[email protected]> wrote:

> Hi
> I would like to be able to type in persons age and have excel place it into
> a category.
>
> eg
> 50 to 59 would be in the 'A' category
> 60 to 65 would be in the 'B' category
> 70 and over would be in the 'c' category
>
> Hope you can make sense of this. Any help would be appreciated.
> Thanks
> Fesk