IF statement w/ several requirments

  • Thread starter Thread starter stevewhite00
  • Start date Start date
S

stevewhite00

I have a list of of stock symbols from which I pull data from. th
problem is that some of the symbols are not stocks, but rathe
indecies. I need to list what each symbol is, whether it's a stock o
an index. Luckily there are only about 5-6 symbols on my list that ar
indecies.

How can I create a formula that effectively says, if [cell ref] equal
"abc", "xyz", "etc", then [cell ref] &" Index", if not, then [cell ref
&" Equity"?

It's easy to setup a formula for just one qualifier =IF(A1="abc", A1&
Index", A1&" Equity") - but i just want to add a couple more.

Any advice? Thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Scrabble Value calculation for Welsh words 0
Formula to search for given term, and if not found in column to add it to list 3
how do i use IF to substitute for another cell? 1
Insert sheet linkage 3
if condition 12
Help needed with Adapting complex INDEX formula 2
IF statement with logical_value that is similar to this 0<a1<10 6
Table_array lookup through a define list 10

Back
Top