How to Use the IF Function in Spreadsheets

Step-by-Step Guide

1. 1

   Step 1: Choose a cell.

   Select the cell where you want to enter the function (usually a blank cell), for example B2.
2. 2

   Step 2: Enter an equal sign.

   The first thing you need to do to type a function is type the equals sign (=). ,, For example =IF(. , As an example, click on cell A2. , For example =IF(A2>100, , Do this followed by a comma.
   
   For example =IF(A2>100,"A is over 100"
   
   . , For example =IF(A2>100,"A is over 100"
   
   "A is less than or equal to 100". , For example =IF(A2>100,"A is over 100"
   
   "A is less than or equal to 100"). , Press Return (or click the tick box) to complete the formula.
3. 3

   Step 3: Type IF.

4. 4

   Step 4: Add open brackets.

5. 5

   Step 5: Select where the results will be displayed.

6. 6

   Step 6: Type the statement value followed by a comma.

7. 7

   Step 7: Type the condition if the statement is satisfied.

8. 8

   Step 8: Type the condition if the statement is unsatisfied.

9. 9

   Step 9: Close the brackets.

10. 10

    Step 10: Complete the formula.

Detailed Guide

About the Author