need help please

W

Wayne

"I want to create a formula that looks at one cell to recognize any one of three different alpha characters and return a different answer depending upon which character is found. If none are found, return false."
 
N

Norman Harker

Hi Wayne:

Try as a basis

=IF(A1="a","Answer 1",IF(A1="b","Answer 2",IF(A1="c","Answer
3",FALSE)))

Strictly speaking you don't need the FALSE as this is the return of
the optional second argument of an IF function:

=IF(A1="a","Answer 1",IF(A1="b","Answer 2",IF(A1="c","Answer 3")))

The formula is not case sensitive.




(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
Wayne said:
"I want to create a formula that looks at one cell to recognize any
one of three different alpha characters and return a different answer
depending upon which character is found. If none are found, return
false."
 
W

Wayne

----- Norman Harker wrote: -----

Hi Wayne:

Try as a basis

=IF(A1="a","Answer 1",IF(A1="b","Answer 2",IF(A1="c","Answer
3",FALSE)))

Strictly speaking you don't need the FALSE as this is the return of
the optional second argument of an IF function:

=IF(A1="a","Answer 1",IF(A1="b","Answer 2",IF(A1="c","Answer 3")))

The formula is not case sensitive.




(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
Wayne said:
"I want to create a formula that looks at one cell to recognize any
one of three different alpha characters and return a different answer
depending upon which character is found. If none are found, return
false."

Norman, thank you so much. It worked. It is exactly what I needed.
 
N

Norman Harker

Hi Wayne!

Thanks for thanks is always appreciated and shows Google searchers a
solution works.

Seasons Greetings

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 

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

Top