IF Statements! Something smells Iffy!

So last week we used conditional formatting to highlight who was coming to our party.

Well the update is . . . . . . . only two people showed up. :(

So now, we are going to use an IF Statement to find out who is still our friend.

In the Friend Status column, we want to write formula that will check if a person didn't show. We'll check for "No" in the adjacent cell and if its true (i.e. they didn't come), then I want to write "Not My Friend" or else, "Still a Friend".

The formula will look like this:

=If(C2= No, "Not My Friend", "Still a Friend")

Now, when we drop the formula, we'll really know what's up.

So that's that. Can't believe Tyson, even said he'd come.