How to Do If Then in Google Sheets | Scribe

    How to Do If Then in Google Sheets

    • Alejandra Arciniegas |
    • 9 steps |
    • 2 minutes
    • Google SheetsGoogle Sheets
    1
    Let's see how to use the IF THEN function in Google Sheets. Start by opening your spreadsheets document.
    2
    Click on the cell where you want to apply your formula.
    3
    Type "=if"
    4
    Now, select the first options from the dropdown below.
    5
    You will see the syntax of the formula.\ "**Logical expression**" refers to a number or an exact cell or text string and a logical operator. The logical operators you can use for your expression are: =, <, >, <>, <=, and >=. "**Value if true**", refers to the input made to the cell when the logical expression is true. "**Value if false**", refers to the input made to the cell when the logical expression is false.
    6
    In this case, the formula I'm typing is ">=10,"yes","no")". Once you do that, hot "enter".
    7
    You will get the result.
    8
    Now, you can click on the little blue dot at the bottom-right corner of the cell, hold it and drag it down the column to replicate the formula for the rest of the cells.
    9
    You will get the result in all of them. That's all!