Nested IF With Combined AND & OR Functions

Nested IF With Combined AND & OR Functions

You will input the data and establish a criteria. In the following example, the selection criteria is that players with batting average above 25 and strike rate above 30 or batting average above 60 will be selected.

In the IF function, you will first insert the OR statement which in this example is batting average should be above 60. We will enter this in Excel as follows:

Now, in the IF function, we will insert the AND statement which in our example is that batting average should be above 25 and strike rate above 30. We will enter this in Excel highlighted as follows:

Finally, we will first input what would be the outcome if criteria is fulfilled and then we will enter what will be the outcome if criteria is not fulfilled. In this case, it is “Select” and “Reject“.

Formula here is:

=IF(OR(AND(B4>60),AND(B4>25,C4>30)),”Select”,”Reject”)

Feel free to use it. Check the image above to see which addresses you may need to change.

Template

Further reading: 
IF Function; Understanding it and Different Ways to Use It 
If Function with multiple conditions 
Basic concepts 
Getting started with Excel
Cell References