### Excel Cram Kit (Exam 2)

AND vs. OR
HLOOKUP
Excel Tables
PivotTables
COUNTIF, SUMIF, AVERAGEIF
SUMPRODUCT
3D Cell References

# What if you have multiple conditions?

If you recall in the IF article, we created a spreadsheet for Michael Scott's C.R.I.M.E.A.I.D. (Crime Reduces Innocence Makes Everyone Angry I Declare) fundraising event.

With our spreadsheet, we created the following IF statement...

=IF(SUM(D:D) >= 1000000, "YES", "NO")

...to determine whether or not the goal of \$1,000,000 was reached for the fundraiser. We then displayed this determination in cell F2.

Challenge question: What if the only potential outcome of the fundraiser was not just whether or not \$1,000,000 was reached?

In other words... what if there were multiple conditions that could result in differing outcomes of the fundraiser?

This is where nested IF statements and IFS come into play!

Nested IF statements and IFS enable us to check if more than one condition is true, and returns the designated value for the first true condition.

To exemplify how we could incorporate multiple conditions into Michael's fundraiser, let's say that if the fundraiser does not surpass \$10,000, then Michael Scott will be forced to sell his very own (and privately held) Threat Level Midnight movie to the local theatre.