Logical Test - Returning Value

[AA+]

How do I return the value of Cell A2 as AA+ or No Degree in Cell B2?


Highest Education Level Description AA+ or No Degree
G-Bachelor's Level Degree AA+
C-HS Graduate No Degree

 

[Jacob Skaria]

With Description in A1 try the below formula in B1

This is based on keyword search. If keywords like Bachelor or degree is
present the formula returns AA+. You can add more keywords to suit your
requirement

=IF(A1<>"",IF(COUNT(SEARCH({"Bachelor","Degree"},A1)),"AA+","No Degree"),"")

If this post helps click Yes

 

[berniean]

I can think of two methods. Which you use depends on the complexity of your
need.

If you only have two choices, a simple If/Then/Else statement will work.

In cell B2 type =IF(A2="G-Bachelor's Level Degree","AA+","No Degree")

You can nest the IF statement for up to seven choices.

If you have more than seven choices, then create a table of those choices
with the Education Level in Column A and the Degree in Column B. Name the
table "Education". Then, in your file that needs the degree, type a VLOOKUP
formula in B2 that looks for the text in A2 in Column A of your new table,
and returns the degree in Column B.

=VLOOKUP(A2,Education,2,false)

HTH,
Bernie

 

[Kassie]

=IF(ISERROR(SEARCH("degree",A3)),"No degree","AA+")

--
HTH

Kassie

Replace xxx with hotmail