IF multiple conditions - combined with AND and OR in Excel
|Hello, I would like to create an excel formula with IF, AND and OR conditions. Until now I didn't use OR, so I used the nested condition and it looked like =IF(A2>5,IF(B2>5,"OK","NOT OK"),"NOT OK"). |
Now I am not sure how to include OR condition into the formula above. Do you know how to do it ?
To create the formula, you have to combine IF, AND and OR functions. The following formula is more simple and will give the same result as the one you are using:
In case of more conditions, it is needed only to add values into AND function. For example:
To add OR condition, you need to include OR function inside AND function. The formula could look like:
The results will be:
You can also include AND function inside OR function when needed.
|How to calculate inverse currency exchange rate ?|
|How to add side by side rows in excel pivot table ?|
|Remove or hide bottom navigation bar with buttons on Android|
|How to change QWERTZ keyboard to QWERTY in Windows 10 ?|
|Invitation emails disappear after meeting is accepted in Outlook|
|How to see who is invited to a meeting - attendees in Outlook|
|How to calculate how many Man Days are 3 Man Hours ?|