How to Create a Formula in Google Sheets | Scribe

    How to Create a Formula in Google Sheets

    • Alejandra Arciniegas |
    • 16 steps |
    • 2 minutes
    • Google SheetsGoogle Sheets
    1
    Creating a formula in Google Sheets is very simple. Let's see how to do it.
    2
    First, open you spreadsheet document. Once you have it, click on the cell that you want to apply the formula to.
    3
    Type "=" and add the formula you need. Let's start by seeing the formulas for basic math operations.
    4
    To apply basic math operations formulas, you should click on the first cell that you need for your operation.
    5
    Now, type +, -, \* or /, depending on if you want yo add, subtract, multiply or divide.
    6
    Then, select the other cell that you need for your operation and then, hit "enter".
    7
    You can also calculate the average of different values by typing "=average"
    8
    Then, click on the "AVERAGE" option from the dropdown.
    9
    Now, select the first cell
    10
    Type ","
    11
    Select the other cell and type "enter".
    12
    But you can also use text formulas! These include CONCATENATE, LEFT, RIGHT and LEN. Let's use "=concatenate" as an example.
    13
    Once you type "=concatenate", click on the option that appears below.
    14
    Now, select the cells you need and separate them by a comma.
    15
    Once you hit enter, you'll get something like this.
    16
    There are many types of formulas you can use. Besides the basic math operations and text ones, you can also find: - Logical functions (IF, AND, OR, NOT) - Lookup functions (VLOOKUP, HLOOKUP, INDEX, MATCH) - Date and time functions (TODAY, NOW, DATE, TIME)