I'm trying to create an if statement with multiple values but it
doesn't seem to be working.

ie...I have a column that has different values (1,2,3,4,5). 1=daily,
2=weekly, 3=monthly, 4= quartely and 6=annually. I would like to have
another cell with the associate value. So, if a1=1 then daily, if a1=2
then weekly, if a1=3 then monthly, etc...

How would I do this?

=CHOOSE(A1,"daily","weekly","monthly","quarterly", "annually")

--
Gary''s Student - gsnu200760

Thanks, that worked.

What do I do if I have a 0 in my 1st column since it seems that the
choose function starts at 1?

=IF(A1=0,"",CHOOSE(A1,etc


--


Regards,


Peo Sjoblom


wrote in message
...
Thanks, that worked.

What do I do if I have a 0 in my 1st column since it seems that the
choose function starts at 1?

I tried that but it didn't work. I showed my field with "0" as
"value##"

What do you mean? If the cell is zero that formula will return a blank cell
and what does "it didn't work" means?

--


Regards,


Peo Sjoblom


wrote in message
...
I tried that but it didn't work. I showed my field with "0" as
"value##"

=LOOKUP(A1,{0,1,2,3,4,5},{"","daily","weekly","mon thly","quarterly","annually"})


" wrote:

I'm trying to create an if statement with multiple values but it
doesn't seem to be working.

ie...I have a column that has different values (1,2,3,4,5). 1=daily,
2=weekly, 3=monthly, 4= quartely and 6=annually. I would like to have
another cell with the associate value. So, if a1=1 then daily, if a1=2
then weekly, if a1=3 then monthly, etc...

How would I do this?

That one returned "#N/A".

BTW, I'm using excel 97

wrote in message
...
That one returned "#N/A".

BTW, I'm using excel 97


Which one? Of what?

PLEASE remember to include sufficient text from the message to which you are
replying to make your reply understandable ON ITS OWN.

On Dec 5, 11:44 am, "Stephen" <none wrote:
wrote in message

...

That one returned "#N/A".

BTW, I'm using excel 97

Which one? Of what?

=LOOKUP(A1,{0,1,2,3,4,5},
{"","daily","weekly","monthly","quarterly","ann ual-ly"}) Returned "#N/
A"

Then cell A1 doesn't contain the numerical value 0. It may be text that
looks like 0, or something else, but it isn't the numerical value 0.

wrote in message
...
On Dec 5, 11:44 am, "Stephen" <none wrote:
wrote in message

...

That one returned "#N/A".

BTW, I'm using excel 97

Which one? Of what?

=LOOKUP(A1,{0,1,2,3,4,5},
{"","daily","weekly","monthly","quarterly","ann ual-ly"}) Returned "#N/
A"

I use '97 as well and it works fine for me.........perhaps your cell is not
empty, but may contain a space...........

Vaya con Dios,
Chuck, CABGx3



" wrote:

That one returned "#N/A".

BTW, I'm using excel 97