For any The Office fans out there, fasten your seatbelts. It's time for the C.R.I.M.E.A.I.D. (Crime Reduces Innocence Makes Everyone Angry I Declare) fundraising event!
In this episode of The Office, Dunder Mifflin gets broken into and robbed, prompting Michael to plan an auction to raise money for the stolen items. His goal: $1,000,000.
If Michael had set up an Excel sheet with all these items, it might look something like this:
We can use an IF function in F2 to determine whether or not Michael meets his $1,000,000 goal!
If his goal is met, this cell will display "YES". If his goal has not been met yet, this cell will display "NO".
IF functions determine whether or not a condition is met, then assume a value depending on if the condition is true or false.
Coding an IF function
To code the C.R.I.M.E.A.I.D. IF function, let's first view the template for IF functions: