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:
Next, if we press Enter, we will get the final total sales value.
2. Subtracting Numbers
For subtracting two values, there is the MINUS function in google sheets. We can use this function like this:
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:
3. Dividing Numbers
Google sheets offer the DIVIDE function to divide a number by another number. The formula looks like this:
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:
- 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)
- Solved: Excel Formulas Not Working in Google Sheets
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:
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:
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:
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:
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:
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:
Read More: Difference Between Google Sheets and Excel
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.