Logical Test - Returning Value

  • Thread starter Thread starter AA+
  • Start date Start date
A

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
 
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
 
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
 
=IF(ISERROR(SEARCH("degree",A3)),"No degree","AA+")

--
HTH

Kassie

Replace xxx with hotmail
 
Back
Top