Formulas are vital elements in Google Sheets and Excel. They are used in automating mathematical tasks. Therefore, learning how to write and use formulas in Google Sheets and Excel would be beneficial. This post will discuss all the workarounds related to formulas in Google Sheets and Excel.

**How to write formulas in Google Sheets**

Table of Contents

Numerous formulas can be used in Google Sheets to solve mathematical queries. Below are some of the ways of using formulas in Google Sheet:

**a) Using formulas with values**

Here are the steps to follow while using this method to write formulas:

**1. **Open the Google Sheet document you want to write the formula.

**2. **Click on the cell that will contain the formula.

**3. **On the selected cell, type the **Equal (=).
**

**4. **Then, type the formula you want to add the formula.

Let us use the Sum formula to explain.

**5. **Type the first value into the formula. That is, **=23
**

**6. **Add the sign to the formula, **=23+
**

**7. **Lastly, add the second value. That is, **=23+67
**

**8. **Finally, click on the **Enter **button.

**b) Using formulas with cell reference**

Steps:

**1**. Open the Google Sheet document you want to write the formula.

**2. **Click on the cell that will contain the formula.

**3. **On the selected cell, type the **Equal (=).
**

**4. **Then, type the formula you want to add the formula.

**5. **Click on the first cell reference you want to add to the formula. That is, **=A1
**

**6. **Next, add the second cell reference. That is **=A1+ B1.
**

**7. **Finally, hit the** Enter button.
**

**How to write formulas in Excel**

Below are some of the ways of using formulas in Excel:

**a) Using the formula tab**

Steps:

**1. **Open the Excel document you want to write the formula.

**2. **Click on the cell that will contain the formula.

**3. **Click on the **Formula tab **on the toolbar.

**4. **From the **Function Library **section, choose the formula you use in the document.

**b) Using formulas with values**

Steps:

**1. **Open the Excel document you want to write the formula.

**2. **Click on the cell that will contain the formula.

**3. **On the selected cell, type the **Equal (=).
**

**4. **Then, type the formula you want to add the formula.

Let us use the Sum formula to explain.

**5. **Type the first value into the formula. That is, **=23
**

**6. **Add the sign to the formula, **=23+
**

**7. **Lastly, add the second value. That is, **=23+67
**

**8. **Finally, click on the **Enter **button.

**c) Using formulas with cell reference**

Steps:

**1. **Open the Excel document you want to write the formula.

**2. **Click on the cell that will contain the formula.

**3. **On the selected cell, type the **Equal (=).
**

**4. **Then, type the formula you want to add the formula.

**5. **Click on the first cell reference you want to add to the formula. That is, **=A1
**

**6. **Next, add the second cell reference. That is **=A1+ B1.
**

**7. **Finally, hit the** Enter button.
**

**To copy formula down the column in Excel and Google Sheets**

Below are the steps to follow:

**1. **Enter the dataset on the empty cells, and click on the cell that will contain the formula

**2. **Type the equal sign (**=) **followed by the formula you want to copy in the selected column. For example, let us use the SUM function. Therefore, we will type this **=SUM (.
**

**3. Select** the first cells and close the bracket. **=SUM (A1, B1) **and press the **Enter Key.
**

**4. **Locate the **Dragging tool **on the cell’s bottom-right side. Drag it downwards to apply the formula to the entire column.

** **