How to return mulitple values based on the contents of another cel
 

Should be simple but I have not been able to figure it out. HELP!

A1 can contain a number between 1 and 50
I am wanting to program A2 to show the result of A, B or C depending on the
value of A1. For example, if:
A1 contains 1 or 4 or 7 or 10, I want the value of A2 to show "A".
A1 contains 2 or 5 or 8 or 11, I want the value of A2 to show "B"
A1 contains 3 or 6 or 9 or 12, I want the value of Aw to show "C"

Thanks for your help!

How to return mulitple values based on the contents of another cel
 

Try

=CHOOSE(A1,"A","B","C","A","B","C","A","B","C","A" ,"B","C")

Mike

"sherlockgr" wrote:

Should be simple but I have not been able to figure it out. HELP!

A1 can contain a number between 1 and 50
I am wanting to program A2 to show the result of A, B or C depending on the
value of A1. For example, if:
A1 contains 1 or 4 or 7 or 10, I want the value of A2 to show "A".
A1 contains 2 or 5 or 8 or 11, I want the value of A2 to show "B"
A1 contains 3 or 6 or 9 or 12, I want the value of Aw to show "C"

Thanks for your help!

How to return mulitple values based on the contents of another cel
 

=IF(OR(A1={1,4,7,10}),"A",IF(OR(A1={2,5,8,11}),"B" ,IF(OR(A1={3,6,9,12}),"C",FALSE)))


hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"sherlockgr" escreveu:

Should be simple but I have not been able to figure it out. HELP!

A1 can contain a number between 1 and 50
I am wanting to program A2 to show the result of A, B or C depending on the
value of A1. For example, if:
A1 contains 1 or 4 or 7 or 10, I want the value of A2 to show "A".
A1 contains 2 or 5 or 8 or 11, I want the value of A2 to show "B"
A1 contains 3 or 6 or 9 or 12, I want the value of Aw to show "C"

Thanks for your help!

How to return mulitple values based on the contents of another
 

Marcelo,
You are a genius!

Thanks!


"Marcelo" wrote:

=IF(OR(A1={1,4,7,10}),"A",IF(OR(A1={2,5,8,11}),"B" ,IF(OR(A1={3,6,9,12}),"C",FALSE)))


hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"sherlockgr" escreveu:

Should be simple but I have not been able to figure it out. HELP!

A1 can contain a number between 1 and 50
I am wanting to program A2 to show the result of A, B or C depending on the
value of A1. For example, if:
A1 contains 1 or 4 or 7 or 10, I want the value of A2 to show "A".
A1 contains 2 or 5 or 8 or 11, I want the value of A2 to show "B"
A1 contains 3 or 6 or 9 or 12, I want the value of Aw to show "C"

Thanks for your help!

How to return mulitple values based on the contents of another cel
 

Another way:

=CHAR(MOD(A1-1,3)+65)

Hope this helps.

Pete

"sherlockgr" wrote in message
...
Should be simple but I have not been able to figure it out. HELP!

A1 can contain a number between 1 and 50
I am wanting to program A2 to show the result of A, B or C depending on
the
value of A1. For example, if:
A1 contains 1 or 4 or 7 or 10, I want the value of A2 to show "A".
A1 contains 2 or 5 or 8 or 11, I want the value of A2 to show "B"
A1 contains 3 or 6 or 9 or 12, I want the value of Aw to show "C"

Thanks for your help!

How to return mulitple values based on the contents of another
 

no I am not.

Thanks for the feedback

--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"sherlockgr" escreveu:

Marcelo,
You are a genius!

Thanks!


"Marcelo" wrote:

=IF(OR(A1={1,4,7,10}),"A",IF(OR(A1={2,5,8,11}),"B" ,IF(OR(A1={3,6,9,12}),"C",FALSE)))


hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"sherlockgr" escreveu:

Should be simple but I have not been able to figure it out. HELP!

A1 can contain a number between 1 and 50
I am wanting to program A2 to show the result of A, B or C depending on the
value of A1. For example, if:
A1 contains 1 or 4 or 7 or 10, I want the value of A2 to show "A".
A1 contains 2 or 5 or 8 or 11, I want the value of A2 to show "B"
A1 contains 3 or 6 or 9 or 12, I want the value of Aw to show "C"

Thanks for your help!