need help please

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

"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."
 
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
Click to expand...
one of three different alpha characters and return a different answer
depending upon which character is found. If none are found, return
false."
 
----- 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
Click to expand...
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.
 
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.
 
Back
Top