One more interesting formula# IF combined with AND / OR

IF combined with AND / OR

Formula: =IF(AND(C2>=C4,C2<=C5),C6,C7)

Anyone who’s spent a great deal of time in 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 or formulas easier to audit and 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.