IF combined with AND / OR
Formula: =IF(AND(C2>=C4,C2<=C5),C6,C7)
Anyone who’s spent a great deal of time doing various types of financial models knows that nested IF formulas can be a nightmare. Combining IF with the AND or the OR function can be a great way to keep formulas easier to audit and easier for other users to understand. In the example below, you will see how we used the individual functions in combination to create a more advanced formula.
For a detailed breakdown of how to perform this function in Excel please see this free guide on how to use IF with AND / OR.
📷
From <https://corporatefinanceinstitute.com/resources/excel/study/advanced-excel-formulas-must-know/>