Equations are often used in our calculations to express a precise and quantitative relationship between various features of our world. Since we heavily use Google Sheets in our day-to-day life, it is apparent that we’ll require inserting equations in Google Sheets. However, unlike Google Docs, we don’t have any built-in feature to insert equations in Google Sheets. In spite of that, I’ll show you 4 easy ways to insert an equation in Google Sheets. The following image contains an overview of the required output. Here, I have inserted a simple equation by applying a formula. Now, let’s learn the ways.

**Table of Contents**hide

## A Sample of Practice Spreadsheet

You can copy our practice spreadsheet by clicking on the following link. The spreadsheet here contains an overview of the demonstrated ways to insert an equation in Google Sheets.

## 4 Tricky Ways to Insert Equation in Google Sheets

Here, we’ll use operators, built-in features, and formulas to insert an equation in Google Sheets. Since Google Docs has an in-house feature to insert equations, we’ll also seek help from it. Now, let’s start.

### 1. Combining Ampersand (&) Operator and CHAR Function

Our first method will use a combination of the **Ampersand** (**&**) operator and **the CHAR function**. The **CHAR** function is able to convert a number into a character. One limitation of this method is that complex equations that contain fractions or any mathematical operators (for example, the Summation, Differential, Integral, etc. operators) can’t be inserted with this method. Now, let’s have a look at the dataset we’ll use for this method. The dataset contains a list of famous formulas for which we’ll write the related equation.

__Steps:__

- Initially, activate
**Cell C5**by double-clicking on it. - Afterward, type in the following formula-

`="E=mc"&CHAR(178)`

- Then, press
**Enter**key to get the required output. Here, the statement**CHAR (178)**converts the decimal code**178**to superscript**2**.

- We need a list of codes for inserting the equations in the remaining cells. Such a list is provided in the worksheet titled “
**Exponent Unicode Lis**t”. Use the required codes from here and complete the formula in other cells.

- The final output looks like the following-

**Read More: ****How to Insert Superscript in Google Sheets (2 Simple Ways)**

### 2. Applying Drawing Tool

In this method, we’ll use the in-house feature of inserting drawings in Google Sheets. We can insert an equation as hand-scribbled text through the **Drawing** tool in Google Sheets. Keep reading to learn how.

__Steps:__

- Firstly, go to the
**Insert**ribbon and select the**Drawing**tool from the pop-up list.

- Consequently, a window like the following will pop up.

- Now, click on the drop-down icon of the
**Line**feature and select the**Scribble**option from the pop-up list.

- Afterward, draw the required equation using the mouse or any external device.

- Then, select the entire equation to view the formatting options. Customize the equation with the required formatting options. Here, I have set the
**Line Weight**to**3px**. - Now, click on the
**Save and Close**option.

- At this point, the hand-scribbled equation will appear in your Google Sheets worksheet.

- At this time, select the equation and hover your mouse pointer above the square blue icons of the equation border. You will be able to resize the drawing by dragging through this.

- Resize the equation and drag it above the required cell to get the required output. One of the limitations of this method is that the inserted equations don’t have aesthetic values.

**Read More: ****How to Insert Signature in Google Sheets (3 Easy Ways)**

### 3. Using Google Docs and Insert Image Option

The previously mentioned ways might be able to insert simple equations but to insert equations with various mathematical operators, we need to insert the equation as an image. Since Google Docs has a built-in feature to insert such complex equations, we’ll use Google Docs to write our required equation and then insert the equation as an image. To demonstrate this example, we’ll insert the equation for Standard Deviation Formula in Google Sheets.

__Steps:__

- First, open a Google Docs file.
- Then, go to the
**Insert**ribbon and select the**Equation**tool from the appearing list.

- Af this point, the features of the
**Equation**tool and a space for inserting the required equation will appear in your Google Docs file.

- Now, use these features to insert the equation for the Standard Deviation formula.

- Now, use any Snipping tool to create a screenshot like the following-

- Next, we have to insert the screenshot in our Google Sheets file. We can insert the screenshot from our Computer or from Google Drive.

**Similar Readings**

**How to Insert a Textbox in Google Sheets (An Easy Guide)****Insert Page Break in Google Sheets (An Easy Guide)****How to Have More than 26 Columns in Google Sheets****Insert Rows Between Other Rows in Google Sheets (4 Easy Ways)****How to Insert Multiple Rows in Google Sheets (4 Ways)**

#### 3.1 Inserting from Computer

Since the screenshot is saved directly on your computer, it’s easier to upload the screenshot from your computer directly. Follow the steps below for this process.

__Steps:__

- In your Google Sheets, first, select
**Cell C5**and then go to the**Insert**ribbon. After that, click on the**Image**feature. Lastly, select**Insert Image in a Cell**option from the two options.

- Consequently, a window like the following will pop up. To insert an image from your computer, click on the
**Browse**option. You can also select the required image and drag it above the window to open it.

- After selecting the
**Browse**option, the**File Explorer**of your computer will open. Open the folder where you saved the screenshot and double-click on it to open the screenshot into your Google Sheets file.

- The final output looks like the following after you insert the image by double-clicking on it.

**Read More: ****How to Insert an Exponent in Google Sheets (3 Easy Ways)**

#### 3.2 Inserting from Google Drive

You can also insert the image from your Google Drive. This option is useful when you are working from a remote computer and you don’t have access to your personal computer. However, the image has to be available in your Google Drive for this method to work.

__Steps:__

- First, upload the screenshot to your Google Drive.

- Now, return to your Google Sheets worksheet and select
**Cell C5**. - After that, go to the
**Insert**ribbon first and then click on the**Image**Lastly, select**Insert Image in a Cell**option from the two options.

- Consequently, a window like the following will pop up. Since we want to insert an image from our Google Drive this time, click on the
**Google Drive**option.

- Finally, from your Google Drive files, double-click on the required image to insert it into your Google Sheets.

- And as you can see, the required equation has appeared in
**Cell C5**.

**Read More: ****How to Insert Error Bars in Google Sheets (3 Practical Examples)**

### 4. Employing IMAGE Function

We can also insert an image of an equation using **the IMAGE function**. This function can insert an image in a cell by using the URL of the image as an argument. This method may sound simple, but there are a few important aspects to employing the **IMAGE** function. Follow the simple steps below.

__Steps:__

- We’ll insert the required image of the equation from Google Drive. Therefore, to get the URL of the image, open your Google drive.
- Now, select the image you want to insert.

- Afterward, right-click with your mouse to pop up a list of options and select the Share command from there.

- At this time, a window like the following will appear. Set the
**General Access**as**Anyone with the Link**and the**Role**as**Editor**for the proper execution of the formula. - Now, click on the
**Copy Link**option to make a copy of the link first and then click on**Done**.

- However, we have to modify the copied link before using it as an argument for the
**IMAGE**function. Although, this is not required in case the image URL is collected from a Google search. - The link we copied is given below-

`https://drive.google.com/file/d/1Sgb0m-LQy49gigJ6Z6t7AO8mtmG5MluN/view?usp=share_link`

- Change this link to the following-

`https://drive.google.com/uc?export=download&id=1Sgb0m-LQy49gigJ6Z6t7AO8mtmG5MluN`

- Here, we have substituted the “
**file/d/**” part with “**uc?export=download&id=**” and removed the “**/view?usp=sharing**” part. - Now, activate
**Cell C5**by double-clicking on it. - Afterward, insert the following formula-

`=IMAGE("https://drive.google.com/uc?export=download&id=1Sgb0m-LQy49gigJ6Z6t7AO8mtmG5MluN")`

- Finally, get the required output by pressing the
**Enter**key from your keyboard.

**Read More: ****How to Insert Formula in Google Sheets for Entire Column**

**Similar Readings**

**How to Insert Serial Numbers in Google Sheets (7 Easy Ways)****Insert Multiple Columns in Google Sheets (2 Quick Ways)****How to Insert a Legend in Google Sheets (With Easy Steps)****Paste and Insert Rows in Google Sheets (3 Easy Ways)****How to Insert a Header in Google Sheets (2 Simple Scenarios)**

## How to Add Equation to Graph in Google Sheets

We can also insert an equation to the graph plotted for a dataset in Google Sheets. Let’s have a look at the following dataset. It contains a list of persons’ salary variations with experience. Now, we will plot a graph for this relation and insert an equation for the trendline.

__Steps:__

- Initially, select the range
**C5:D11**and then go to the**Insert**ribbon to select the**Chart**feature from the appearing list of options.

- At this point, a
**Scatter Chart**like below will appear.

- Now, select the chart and click on the vertical ellipsis (
**⋮**) symbol. - Consequently, a list of options will pop up. Select the
**Edit Chart**feature from the list.

- At this time, a sidebar like the following will appear. Go to the
**Customize**menu.

- Afterward, select the
**Series**option from**Customize**menu.

- Now, click on the checkbox of
**Trendline**to activate its features.

- As soon as you check the checkbox of Trendline, a set of features will appear.
- You can use the
**Type**,**Line Color**,**Line Opacity**, and**Line Thickness**features to customize the trendline. - Now, click on the drop-down icon of
**Label**and select the**Use Equation**option from the drop-down list.

- The chart now looks like the following. And as we can see, an equation has been inserted in our chart.

## How to Add Formula as Equation in Google Sheets

The formulas we use in Google Sheets are also a type of equation. Therefore, let’s learn how to Insert Google Sheets formulas as Equation. Let’s have a look at the dataset below. It contains a list of students’ marks attained in 3 different tests. We want to enumerate the maximum number attained by each student. So, let’s start.

**Steps:**

- Initially, select
**Cell F6**. - Then, go to the
**Insert**ribbon and select the**Function**option. - After that, a list of functions will appear. Since we want to enumerate the maximum marks for each student, click on the
**MAX**function.

- As soon as you click on the
**MAX**option, it will appear on the**F6**cell and formula bar. Also, a pop-up of the**MAX**function with its arguments will appear.

- Now, select the range
**C6:E6**by dragging the mouse pointer over the cells to insert the range as arguments for the**MAX**function inserted previously.

- Now, get the required output by pressing the
**Enter**key from your keyboard.

- However, we can also insert functions from the
**Clipboard**menu in Google Sheets. Or, we can simply type it in the required cell.

- Now, for the rest of the cells, we’ll use the auto-fill feature. For that, select sell
**F6**again and hover your mouse pointer above the bottom right corner of the selected cell. - At this time, the
**Fill Handle**icon will be visible. Finally, use it to copy the formula to other cells of**Column F**.

- The final output looks like the following. Using these simple steps, you can insert any formula as an equation in Google Sheets.

## Things to Be Considered

- The Unicode used as an argument for the
**CHAR**function has to be in decimal. - For proper execution of the
**IMAGE**function, we have to set the**General Access**as**Anyone with the Link**and the**Role**as**Editor**for that image in your Google Drive. - In the case of using images from Google, we can insert the copied URL directly as an argument in the
**IMAGE**However, you have to modify the URL if you are inserting an image from Google Drive.

## Conclusion

This concludes our article to learn how we can insert an equation in Google Sheets. I hope the demonstrated examples were ideal for your requirements. Feel free to leave your thoughts on the article in the comment box. Visit our website **OfficeWheel.com** for more helpful articles.

## Related Articles

**How to Insert Button in Google Sheets (5 Quick Steps)****Add Parentheses in Google Sheets (5 Ideal Scenarios)****How to Insert Blank Column Using QUERY in Google Sheets****Insert Yes or No Box in Google Sheets (2 Easy Ways)****How to Insert a Drop-Down List in Google Sheets (2 Easy Ways)****Insert Sparklines in Google Sheets (4 Useful Examples)****How to Insert Video in Google Sheets (2 Easy Ways)**