Excel If Cell Contains Text Then Return Value

Introduction to Excel Conditional Statements

Excel is a powerful spreadsheet software that offers various functions to manipulate and analyze data. One of the most commonly used functions in Excel is the IF function, which allows users to make decisions based on specific conditions. In this article, we will explore how to use the IF function to return a value if a cell contains specific text.

Understanding the IF Function

The IF function in Excel is used to test a condition and return one value if the condition is true and another value if the condition is false. The syntax for the IF function is:

IF(logical_test, [value_if_true], [value_if_false])

Where:

• logical_test is the condition that you want to test
• value_if_true is the value that you want to return if the condition is true
• value_if_false is the value that you want to return if the condition is false

Using the IF Function to Check for Text

To use the IF function to check if a cell contains specific text, you can use the following formula:

=IF(ISNUMBER(SEARCH(“text”,A1)), “Value if true”, “Value if false”)

Where:

• “text” is the text that you want to search for
• A1 is the cell that you want to search in
• “Value if true” is the value that you want to return if the text is found
• “Value if false” is the value that you want to return if the text is not found

The SEARCH function is used to search for the text in the cell, and the ISNUMBER function is used to check if the result of the SEARCH function is a number. If the result is a number, it means that the text was found, and the IF function returns the value specified in the “Value if true” argument.

Example Use Cases

Here are a few examples of how you can use the IF function to check for text in a cell:

• =IF(ISNUMBER(SEARCH(“yes”,A1)), “Approved”, “Rejected”)
• =IF(ISNUMBER(SEARCH(“pending”,A1)), “In Progress”, “Completed”)
• =IF(ISNUMBER(SEARCH(“error”,A1)), “Error Found”, “No Error”)

Using the IF Function with Multiple Conditions

You can also use the IF function with multiple conditions by nesting multiple IF functions together. For example:

=IF(ISNUMBER(SEARCH(“yes”,A1)), “Approved”, IF(ISNUMBER(SEARCH(“pending”,A1)), “In Progress”, “Rejected”))

This formula checks if the cell contains the text “yes”, and if so, returns “Approved”. If not, it checks if the cell contains the text “pending”, and if so, returns “In Progress”. If neither condition is true, it returns “Rejected”.

Table of IF Function Examples

Formula	Description
=IF(ISNUMBER(SEARCH(“text”,A1)), “Value if true”, “Value if false”)	Check if cell A1 contains the text “text”
=IF(ISNUMBER(SEARCH(“yes”,A1)), “Approved”, “Rejected”)	Check if cell A1 contains the text “yes” and return “Approved” or “Rejected”
=IF(ISNUMBER(SEARCH(“pending”,A1)), “In Progress”, “Completed”)	Check if cell A1 contains the text “pending” and return “In Progress” or “Completed”

📝 Note: The IF function is case-sensitive, so make sure to use the correct case when searching for text.

In summary, the IF function is a powerful tool in Excel that allows you to make decisions based on specific conditions. By using the IF function with the SEARCH and ISNUMBER functions, you can check if a cell contains specific text and return a value accordingly. With practice and experience, you can become proficient in using the IF function to automate tasks and make your work more efficient.