**Excel IF statement with multiple AND/OR conditions, nested IF …**
https://www.ablebits.com/office-addins-blog/2014/12/03/excel-if-function-iferrror-ifna/

Dec 03, 2014 · To better illustrate the point, let's have a look at a few IF examples with multiple conditions. Example 1. Using IF & AND function in Excel. Suppose, you have a table with the results of two exam scores. The first score, stored in column C, must be equal to or greater than 20. The second score, listed in column D, must be equal to or exceed 30.

**DA:** 84 **PA:** 92 **MOZ Rank:** 45