In this tutorial, I am going to show you** 6** differences between excel and google sheets formulas. From this, you will know when to use google sheets instead of excel or vice-versa. Throughout this tutorial, you will also learn some important techniques in excel and google sheets which will be very useful in any excel related task.

## Download Practice Workbook

You can download the practice workbook from here.

## 6 Differences Between Excel and Google Sheets Formulas

We have taken a concise dataset to explain the steps clearly. The dataset has approximately **4 **rows and **2 **columns. Initially, we are keeping all the cells in **General **format. For all the datasets, we have **2 **unique columns which are **Months **and **Sales (units)**. Although we may vary the number of columns later on if that is needed.

### 1. Adding Two Numbers

To add two specific numbers in google sheets, we have to insert the following formula using **the ADD function**:

`=ADD(C5,C6)`

Next, if we press **Enter**, we will get the final total sales value.

To add these same numbers in **excel**, we will have to use** the SUM function**. The formula is like below:

`=SUM(C5,C6)`

**Read More:** **How to Copy from Excel and Paste to Google Sheets with Formulas**

### 2. Subtracting Numbers

For subtracting two values, there is **the MINUS function** in google sheets. We can use this function like this:

`=MINUS(C5,C6)`

Then, we press **Enter **to get the subtraction value of the two-month sales.

To perform this same subtraction operation in excel, we need to use the** minus(-)** operator. We can enter the formula below:

`=C5-C6`

### 3. Dividing Numbers

Google sheets offer **the DIVIDE function** to divide a number by another number. The formula looks like this:

`=DIVIDE(C4,C5)`

Now, upon pressing the **Enter **key we should get the value from the division operation as average sales.

Again, there is no dedicated function in excel to perform division between two numbers. For this, we have to use the **Division(/)** operator. The formula for this is below:

`=C4/C5`

**Similar Readings**

**Import Data from Excel to Google Sheets (2 Easy Ways)****How to Copy from Excel to Google Sheets (4 Easy Methods)****How to Convert Excel Sheet to Google Sheets (3 Easy Ways)**

### 4. Multiplying Numbers

If we want to do multiplication in google sheets, there is another dedicated function which is **the MULTIPLY function**. We can use this function as in the below formula:

`=MULTIPLY(C4,C5)`

Next, press the **Enter **key and this will calculate the multiplication value inside cell **C6**.

In excel, we can do simple multiplication using the **Multiplication**(*) operator. The sample formula is as below:

`=C4*C5`

### 5. Finding Power of a Number

There is also a dedicated function in google sheets to calculate the power of a specific number. It is **the POW function** that gives us this option. We can use this function as in the formula below:

`=POW(C4,C5)`

After we press **Enter**, this formula will instantly give us the result as 2560000.

**The POWER function** in excel provides the same functionality as the previous function of google sheets. They differ only in how we write them inside the formula. Here is an example of how we can use this function inside excel:

`=POWER(C4,C5)`

**Read More:** **Pros and Cons of Google Sheets vs Excel – Which Will Be Better?**

### 6. Comparing Two Values

To compare two values in google sheets, we have **the EQ function** which checks the input values for equality and gives the output as **TRUE **or **FALSE**. Let us see how to write this function in a formula:

`=EQ(C5,C6)`

Then, if we press the **Enter **key, we will get the result as **FALSE **in this case.

Here, excel gives a really simple way to compare two values for equality. We just need to use the **Equal(=)** operator for this. Below is an example of how to do this in practice:

`=C5=C6`

**Read More:** **Difference Between Google Sheets and Excel**

## Conclusion

I hope that you were able to understand the points that I showed in this tutorial on the differences between excel and google sheets formulas. As you can see, there are quite a few distinct formulas that are present in google sheets but not in excel. So wisely choose the one that suits your need. If you get stuck in any of the points, I recommend going through them a few times to clear up any confusion. Lastly, to learn more **excel** techniques, follow our **ExcelDemy** website. If you have any queries, please let me know in the comments.