# Google Sheets: Use an IF Function with 3 Conditions

You can use the following formulas to create an IF function with 3 conditions in Google Sheets:

Method 1: Nested IF Function

`=IF(C2<15, "Bad", IF(C2<20, "OK",  IF(C2<25, "Good", "Great")))`

Method 2: IF Function with AND Logic

`=IF(AND(A2="Mavs", B2="Guard", C2>25), "Yes", "No")`

Method 3: IF Function with OR Logic

`=IF(OR(A2="Mavs", B2="Guard", C2>25), "Yes", "No")`

The following examples show how to use each formula in practice with the following dataset in Google Sheets: ## Example 1: Nested IF Function

We can type the following formula into cell D2 to return a specific value based on the value for each player in the Points column:

`=IF(C2<15, "Bad", IF(C2<20, "OK",  IF(C2<25, "Good", "Great")))`

We can then drag and fill this formula down to each remaining cell in column D: Here’s what this formula did:

• If the value in the Points column is less than 15, return Bad.
• Else, if the value in the Points column is less than 20, return OK.
• Else, if the value in the Points column is less than 25, return Good.
• Else, return Great.

## Example 2: IF Function with AND Logic

We can type the following formula into cell D2 to return “Yes” if three conditions are met for a specific player or “No” if at least one of the conditions is not met:

`=IF(AND(A2="Mavs", B2="Guard", C2>25), "Yes", "No")`

We can then drag and fill this formula down to each remaining cell in column D: Here’s what this formula did:

• If the value in the Team column was “Mavs” and the value in the Position column was “Guard” and the value in the Points column was greater than 25, return Yes.
• Else, if at least one condition is not met then return No.

Notice that only one row returned “Yes” because only one row met all three conditions.

## Example 3: IF Function with OR Logic

We can type the following formula into cell D2 to return “Yes” if one of three conditions are met for a specific player or “No” if none of the conditions are met:

`=IF(OR(A2="Mavs", B2="Guard", C2>25), "Yes", "No")`

We can then drag and fill this formula down to each remaining cell in column D: Here’s what this formula did:

• If the value in the Team column was “Mavs” or the value in the Position column was “Guard” or the value in the Points column was greater than 25, return Yes.
• Else, if none of the conditions are met then return No.

Notice that six total rows returned “Yes” because each of those rows met at least one of the three conditions.