Google Sheets IF Statement With Dropdown: Examples

Yes. In Google Sheets, an IF formula can read the value selected in a dropdown and return a result based on that choice. For example, if a status dropdown is in A2, a formula in B2 can display a message when the user chooses Approved: =IF(A2="Approved","Ready to ship","Hold").

How an IF statement works with a dropdown

A dropdown is a way to control what can be entered in a cell; it does not perform the calculation itself. The IF formula checks the cell’s current value and displays one result if a condition is true and another if it is false. In the example above, B2 displays “Ready to ship” when A2 contains Approved. For Pending, Rejected, or another value, it displays “Hold.”

The basic pattern is =IF(condition, result_if_true, result_if_false). The condition can compare a dropdown cell with text, a number, or another cell. The returned result can be a label, a number, or another formula. The dropdown and the formula are separate: changing the selected option updates the formula result automatically.

Before entering a formula, decide what should happen for every possible choice, including an empty dropdown. This avoids a sheet that appears to work for one option but gives a confusing answer for the others.

Create a dropdown in Google Sheets

In Google Sheets in a web browser, you can add a dropdown from the Insert menu or configure it with data validation. To create a basic list directly in a cell:

Select the cell or range where people should make a selection.
Choose Insert > Dropdown. You can also choose Data > Data validation to create or edit a rule.
Add the options, such as Approved, Pending, and Rejected. If you use the data-validation panel, select a dropdown criterion and enter the choices or specify a range containing them.
Set the display style and decide whether invalid entries should be rejected or merely accompanied by a warning.
Choose Done, then select an option in the cell to confirm the list works.

For a list that will be reused or updated, keeping the options in a separate range can be easier to maintain than typing them into each rule. If the options are in H2:H4, set the dropdown to use that range. Changing an item in the source list can then update the available choices. Use a clear header and keep the source list free of unrelated values so it is easy to manage.

A dropdown can appear as a chip or another supported display style. That appearance does not change how an IF formula reads the selection: the formula refers to the cell address, not the color or visual style of the choice. If you copy a dropdown rule to other rows, check that each row’s formula refers to its own dropdown cell.

Build a useful status formula

Suppose A2 contains a dropdown with Approved, Pending, and Rejected. With that layout, enter this in B2 to return a distinct message for each choice:

=IF(A2="Approved","Ready to ship",IF(A2="Pending","Waiting for review",IF(A2="Rejected","Do not ship","Choose a status")))

The formula checks the conditions from left to right. If A2 is Approved, it returns Ready to ship and stops. If not, it checks whether A2 is Pending, then whether it is Rejected. If none match, it displays Choose a status. For the three listed choices, the results are respectively “Ready to ship,” “Waiting for review,” and “Do not ship.” An empty cell also produces “Choose a status.”

Nested IF formulas are useful for a few outcomes, but they become difficult to read when many choices are involved. Google Sheets also has IFS, which checks conditions in order and returns the result for the first true condition. With A2 holding the same status dropdown, this version returns the same messages and includes a fallback:

=IFS(A2="Approved","Ready to ship",A2="Pending","Waiting for review",A2="Rejected","Do not ship",TRUE,"Choose a status")

The final TRUE condition acts as the default because it is always true. Put it last; any conditions after it will never be reached. If there are only two possible outcomes, a basic IF is usually clearer than IFS.

Handle blanks and unexpected values

A blank dropdown cell is a common source of surprising output. If the formula says “Hold” whenever the selected value is not Approved, it will also say “Hold” before anyone has made a selection. That may be correct for a workflow, but a blank-specific result is often clearer.

With the dropdown in A2, use this formula in B2 when an empty cell should remain visually empty and every nonblank choice should be checked:

=IF(A2="","",IF(A2="Approved","Ready to ship","Hold"))

It returns a blank when A2 is empty, “Ready to ship” for Approved, and “Hold” for any other nonblank value. If you want to identify an unexpected value rather than treat it as Hold, add another outcome or use an explicit fallback such as “Check status.” This is especially useful if the validation rule permits warnings instead of rejecting entries, or if data is pasted into the cell.

Text choices in the formula must correspond to the dropdown choices. A spelling difference, extra space, or different punctuation can make a comparison fail. Google Sheets text comparisons with = are generally not case-sensitive, so Approved and approved match, but a trailing space can still cause a mismatch. The simplest fix is usually to standardize the option text in the dropdown and formula rather than trying to compensate for inconsistent labels.

Use dropdown choices to calculate numbers

An IF formula can return a number as well as text. For example, a dropdown can select a service level and the formula can return a corresponding fee, score, or processing time. Keep the example strictly illustrative: it shows formula behavior, not a recommendation about real-world pricing.

Assume A2 is a dropdown containing Standard or Express. With the selected service in A2, enter this formula in B2 to return an illustrative number of processing days:

=IF(A2="Standard",5,IF(A2="Express",2,""))

For Standard, the result is 5; for Express, it is 2; and for a blank or unrecognized choice, the result is blank. If another calculation needs the result, keep the formula output numeric rather than returning a number written as text. For instance, returning 2 as a number is more useful for arithmetic than returning "2 days" as text. A separate cell can add explanatory wording if needed.

If a dropdown has many options with different numbers, consider keeping the choices and their corresponding values in a small lookup table instead of expanding a long nested IF. A lookup approach is easier to update when options change, while a short IF can be quicker to understand for just two or three fixed outcomes.

Apply the formula to multiple rows

For a task list, put the dropdown in A2:A20 and the result formula in B2:B20. Enter the formula for the first row, then fill it down using the small square at the lower-right corner of the selected cell. Because A2 is a relative reference, the copied formula changes to A3 in the next row, A4 after that, and so on. You can also copy and paste the formula into the rest of the result range.

As a concrete example, with each row’s dropdown in column A, put this in B2 and fill it down:

=IF(A2="Complete","Closed","Open")

When A2 is Complete, B2 displays Closed; for any other value, including a blank, it displays Open. If a blank should not count as Open, use a blank check first. If the dropdown or result cells are in different columns in your own sheet, adjust the cell references to match. When copying formulas, do not lock the row with dollar signs unless you specifically want every row to check the same dropdown cell.

IF formulas versus conditional formatting

Use IF when you want a cell to contain a result that can be read, counted, copied, or used in later calculations. Use conditional formatting when the value itself should stay the same but its appearance should change. For example, an IF formula could write “Late” in a result column, while conditional formatting could color the row when a dropdown says Late.

To format cells based on a dropdown in Google Sheets, select the cells to format and choose Format > Conditional formatting. Add a rule that applies when the selected cell text matches the desired option, then choose a formatting style. If the range contains multiple rows, check that the rule uses the right reference for each row. Conditional formatting does not write a new value into a cell, so it is not a substitute for a formula when you need a separate status or calculation.

You can use both tools together: let IF generate a clear result in one column and conditional formatting make important results easier to notice. Avoid relying on color alone to communicate a critical status, since a text label is easier to understand and remains available to formulas and assistive technologies.

Troubleshoot common dropdown formula problems

The formula always returns the fallback. Compare the dropdown option and the text inside the formula character by character. Look for extra spaces, different punctuation, or a formula pointing to the wrong cell.
The formula displays as text. Check that the formula begins with = and that the cell is not set to plain text. Re-entering the formula after correcting the cell format can help.
The formula works in one row but not another. Check whether the formula was filled down and whether each row refers to its own dropdown cell. A reference accidentally fixed to A2 will keep checking that same cell.
Blank cells show an unwanted result. Add an initial test for an empty cell and choose whether the result should be blank, a prompt, or a default status.
A pasted value is not in the dropdown. Review the data-validation rule and whether it rejects invalid data or only shows a warning. A pasted value can also contain spaces or text that is not one of the intended options.
Separators cause a formula error. Google Sheets normally shows commas between arguments in examples, but spreadsheet locale settings can affect formula separators and number formats. Follow the syntax accepted by the sheet’s locale if it expects semicolons.

If the result still looks wrong, test one row with a simple formula that returns the selected cell itself, then verify the exact option shown. This helps distinguish a dropdown or input issue from a problem in a longer nested formula. Also confirm the formula is in a different cell from the dropdown; a formula cannot both occupy and read the same cell in this setup.

Google Sheets and Excel differences

The examples here use Google Sheets in a web browser. Excel also supports IF formulas and dropdown lists, but its menus and validation workflow differ. In Excel for Microsoft 365 on Windows, dropdown lists are typically configured through Data > Data Validation, while conditional formatting is under Home > Conditional Formatting. Do not follow those Excel ribbon paths in Google Sheets; use the Google Sheets menus described above.

The core IF idea is familiar across both programs, but do not assume every feature or menu behaves identically. In either application, the formula needs to refer to the cell containing the selection, the compared text must match an available choice, and the blank case should be considered deliberately. If a workbook or sheet uses a locale with different argument separators, use the separator accepted by that file.

Frequently Asked Questions

Can a Google Sheets dropdown trigger an IF formula automatically?
Yes. Put the IF formula in a separate cell and refer to the dropdown cell. When someone changes the selection, Sheets recalculates the formula result automatically.

How do I make an IF formula return a blank for an empty dropdown?
Check whether the dropdown cell equals an empty string first, then return an empty string for that case. For example, with the dropdown in A2, use =IF(A2="","",IF(A2="Approved","Yes","No")). It leaves the result blank when A2 is empty.

Can one dropdown choice return a different result for every option?
Yes. Use a nested IF for a few choices or IFS to list condition-and-result pairs, followed by a default condition if appropriate. For a long list, a lookup table can be simpler to maintain.

Can I use a dropdown to return a number instead of text?
Yes. Return numeric values in the IF formula, such as 5 for one option and 2 for another. Those results can then be used in arithmetic, provided the formula returns numbers rather than number-like text.

Why does my formula not recognize the selected option?
Most often, the formula references the wrong cell or its comparison text does not exactly match the dropdown choice. Check spelling, spaces, punctuation, and the formula’s row references. Also check whether the cell was manually changed or pasted with a value outside the validation list.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.