IF | CSE 148 – Excel Exam 1

IF explained

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!

(I do not own this image. Rights to The Office and YouTube for this image. Educational purposes only.)

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:

PAID CONTENT

This is the end of the preview. To unlock the rest, get the Excel Cram Kit (Exam 1) or Lifetime Access.

Already purchased? Click here to log in.

Leave a Comment