11 STEPS
1. The IF function is a powerful way to parse data in a spreadsheet and make it more usable for teachers. First, open your desired spreadsheet and click in the cell you want the function. Then click insert, and scroll down to "function"
2. With your mouse, hover All►
3. Click IF
4. The IF function is now in my cell. It will return one value if a logical expression is `TRUE` and another if it is `FALSE`.
First, we must set what that expression is. We can do so by clicking into the cell that contains said expression.
5. Click highlight
6. In the IF Formula, the first value sets the expression to be measured, the second sets what should be returned if the expression is present, the third represents what should be displayed if the expression is not present.
7. You'll see here that Q2 now returns "Yes" brecause O2 is "true" (it has disagree in the box". This teacher is using this function to see which students to build a relationship based on survey responses.
8. If I now click and drag the little blue square in Q2, it will now automatically apply our function to each row.
9. You can see when the student "agrees" with O2, our function tells the teacher that their relationship should be as much of a focus right now, as it's not a trouble spot.
10. Click highlight
11. That's it. You're done.
