Disclosure: This post may contain affiliate links, meaning when you click the links and make a purchase, we receive a commission.

Differences Between Excel and Google Sheets Formulas

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)

differences between excel and google sheets formulas

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

differences between excel and google sheets formulas in adding numbers

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)

differences between excel and google sheets formulas in subtracting numbers

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)

differences between excel and google sheets formulas in dividing numbers

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


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)

differences between excel and google sheets formulas in multiplying numbers

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)

differences between excel and google sheets formulas in finding power

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.


Related Articles

Nazmul Hossain Shovon

Nazmul Hossain Shovon

Hello, I am Nazmul Hossain. I am currently working full-time in Exceldemy as an Excel & VBA Content Developer. I have completed my bachelors in Naval Architecture and Marine Engineering from Bangladesh University of Engineering and Technology. I am interested in working with MS Excel. I also like coding web applications a lot.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo