## DEV Community is a community of 603,512 amazing developers

We're a place where coders share, stay up-to-date and grow their careers.

loading...

# Excel Formulas to Test If a Cell Value is X and (Y or Z)!! Andrews Originally published at geekexcel.com on ・3 min read

On our blog, we have already learned the formula to test if a cell value is X or Y and Z in Excel. In this article, we are going to learn the simple formula to test the cell value with more logical functions like X and (Y or Z) in Excel. Let’s get into this article!! Get an official version of ** MS Excel** from the following link: https://www.microsoft.com/en-in/microsoft-365/excel If cell value is X and Y or Z

## General Formula:

• To test the cell value based on logical functions in Excel, use the below formula.

=IF(AND(A1=”x”,OR(B1=”y”,B1=”z”)),”x”,””)

## Syntax Explanations:

• IF – In Excel, the IF function helps to return one value for a TRUE result, and another for a FALSE result.
• AND – The AND Function checks multiple Conditions and returns **TRUE **if all the conditions are evaluated as true otherwise returns FALSE.
• OR – It is a logical function to test multiple conditions at the same time. The OR Function helps to return either TRUE or FALSE.
• A1, B1 – It is the input data from your worksheet.
• Comma symbol (,) – It is a separator that helps to separate a list of values.
• Parenthesis () – The main purpose of this symbol is to group the elements.

## Practical Example:

Let’s consider the below example. Here we will show how to perform the more complex logic functions in Excel.

• First, we will enter the input values in Column B to Column D. Input Ranges

• Here, we are going to select the candidates based on their course and grades.
• Apply the above-given formula in the formula bar section and press the “Enter” key. Enter the formula

• Now, the result will be displayed in the selected cell. Result

## Wrap-Up:

From this tutorial, you can get some clarification on how to test the cell value based on logical functions such as X and (Y or Z) in Excel? Please feel free to state your query or feedback for the above article. To learn more, check out *Geek Excel **and Excel Formulas *!! **

## Discussion (0) 