Google sheets, if statement multiple conditions

if-statement google-sheets worksheet-function
Bret Allan picture Bret Allan · Nov 15, 2017 · Viewed 40.9k times · Source

Trying to make an if statement that will return 4 outcomes based on the contents of the cell

If the cell is "Yes", "No", "NA", "Unknown", to return 0, 1, 2, 3 respectively.

I can use If(A1="Yes", 0,1) but not sure how to handle the other conditions

Answer

TheMaster picture TheMaster · Nov 15, 2017

SWITCH would be a better call: 

=SWITCH(A1,"Yes",0,"No",1,"N/A",2,"Unknown",3,"I'-'I")

Related questions

Multiple IF statements between number ranges

I'm trying to set up a formula with multiple IF statements between number ranges but I'm seeing the error: Formula parse error Here is the forumula: =IF((AND(A2>0,A2<500),"Less than 500", If(AND(A2>=500,A2<1000),"…

Read More
TEXTJOIN only when the condition is met?

I tried using TextJoin function with IF in it, but it somehow doesn't seem to work. I think I've written the formula correctly, but it doesn't give the solution I'm attempting to get. Objective: I want the values from A-column …

Read More
How do I perform an IF...THEN in an SQL SELECT?

How do I perform an IF...THEN in an SQL SELECT statement? For example: SELECT IF(Obsolete = 'N' OR InStock = 'Y' ? 1 : 0) AS Saleable, * FROM Product

Read More