In this article, we will learn to apply multiple conditions in a single formula using OR and AND function with the IF function.
IF function in Excel is used to check the condition and returns value on the basis of it.
OR function works on logic_test. It helps you run multiple conditions in Excel. If any one of them is True, OR function returns True else False.
AND function works on logic_test. It helps you run multiple conditions in Excel. If every one of them is True, then only AND function returns True else False.
First we will use IF with OR function.
We got the result.
You can use IF and OR function to meet multiple conditions in a single formula.
Now we will use IF with AND function in Excel.
Copy the formula in other cells, select the cells taking the first cell where the formula is already applied, use shortcut key Ctrl + D
We got the Results corresponding to the Scores.
You can use IF and AND function to meet multiple conditions in a single formula.
Hope you understood IF, AND and OR function in Excel 2016. Find more articles on Logic_test here. Please share your query below in the comment box. We will assist you.
The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.