How do I use an IF function if there are three possible values?

When you have more than 2 potential values for entry, use a nested IF statement. In your case, since there are 3 potential values, you will need to create a logical test for criteria for all but 1 of these potential value. The untested becomes the "value if false" entry. Think back to the if statement function: =if(logical test, value if true, value if false). In a nested if statement, the logical test and the value if true is repeated within the if statement function until you are left with only 1 remaining value (value if false) for entry. For example: =if(logical test 1, value if true, if(logical test 2, value if true, if(logic test 3,value if true, value if false))).