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.
Commentaires