If statement

[Hendrix10]

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?

 

[Gary''s Student]

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

 

[Hendrix10]

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?

 

[Peo Sjoblom]

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


--


Regards,


Peo Sjoblom

 

[Teethless mama]

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

 

[Hendrix10]

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

 

[Peo Sjoblom]

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

 

[Hendrix10]

That one returned "#N/A".

BTW, I'm using excel 97

 

[Hendrix10]

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

When I put in the =if(A1=0,"", choose, etc)....I received a return of
"#value!"
not a blank cell.

 

[Stephen]

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.

 

[Hendrix10]

Which one? Of what?

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

 

[CLR]

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

 

[Peo Sjoblom]

Not if you use

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

I don't understand why you would change my formula and use "0" instead?
Where did I put those
quotes?


--


Regards,


Peo Sjoblom

 

[Stephen]

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.

 

[Hendrix10]

This is exactly what my formula looks like:

=IF(Q2=0,"",CHOOSE(Q2,"Weekly","Monthly","Quarterly","Every Four
Months","Semi Annually","Annually"))

Q2 is the field in my worksheet that I'm referencing to.

 

[Harlan Grove]

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.

....

Picky: given all the other messages in this thread, it's nearly
certain the OP's A1 cell contains text rather than a numeric 0 or
nothing at all. However, if the cell contained a very small negative
numeric value, so small that it would display as 0, that would also
cause the LOOKUP formula to return #N/A.

 

[Harlan Grove]

(e-mail address removed) wrote...

This is exactly what my formula looks like:

=IF(Q2=0,"",CHOOSE(Q2,"Weekly","Monthly","Quarterly",
"Every Four Months","Semi Annually","Annually"))

Q2 is the field in my worksheet that I'm referencing to.

....

Try changing this to

=IF(N(Q2)=0,"",CHOOSE(Q2,"Weekly","Monthly","Quarterly",
"Every Four Months","Semi Annually","Annually"))

 

[Hendrix10]

It's working. There was an extra space in the cells.


Thanks everyone for your help.

 

[TRYING]

If this applies, as an added precaution, you might want to use Data
Validation to limit the choices of what can be entered in cell Q2 to 1 to 6
(right now you have 6 choices) or whatever highest number applies. Depending
on your preference or personality, this might be totally unnecessary.

Since CHOOSE only uses values from 1 to 254, it seems the number 0 shouldn't
be included among your choices.