- Simplify complex calculations with a few simple steps
- Why use a function?
- Google Sheets Function Syntax
- Using Google Sheets features
- Using complex functions in Google Sheets
- Using functions with text in Google Sheets
Simplify complex calculations with a few simple steps
Google Sheets is a powerful spreadsheet program that performs complex calculations on the data entered in each cell. The app uses formulas and functions to do these tasks so you don’t have to. A formula is an expression you enter to tell Google Sheets how to calculate the value of a cell, while a function is a predefined formula that Google Sheets created for you.
The instructions in this article apply to Google Sheets.
Why use a function?
The difference between a formula and a function is that you create formulas to perform calculations, while functions are ready-made formulas that you can find in Google Sheets. Features save time and reduce the chance of errors.
For example, to add a series of numbers with a formula, enter the following in a cell in Google Sheets:
= A1 + B1 + C1 + D1 + E1 + F1
To add the same sequence of numbers with a function, enter:
Using a function is effective when working with a large number of elements or when doing more complex calculations.
Google Sheets Function Syntax
Each function has a syntax, which is a specific order in which the elements for the function are entered to perform the required calculation.
Each function begins with a function name followed by arguments, separated by commas or colons and enclosed in parentheses. Main function design:
function_name (аргумент1, аргумент2)
Here’s an example:
СУММ (A1, B1)
Using Google Sheets features
The fastest and easiest way to use the function is through the menu Functions †
Select the cell where you want to display the result of the calculation.
Select from the toolbar Functions and then select a function. There are five main functions, plus submenus containing all possible functions. Five main functions:
- SUM : Adds values to a range of cells.
- AVERAGE † † Calculates the average value in a range of cells.
- COUNT † Specifies the number of values in a range of cells.
- MAX † † Returns the maximum value in a range of cells.
- MIN † † Provides the lowest value in a range of cells.
Select cells to include in the range.
To select individual cells instead of consecutive cells, hold . pressed ctrl and make your choice. Loves . pressed to select a continuous range of cells Shift and select the first and last cells in the range.
Click Enter †
The result appears in the selected cell.
Using complex functions in Google Sheets
Google Sheets contains dozens of functions that perform different tasks. For example, to calculate the number of days or the number of working days (Monday to Friday) between two dates.
See the full list of Google Sheets features to find the feature you need. To narrow your options, enter your search term in the box Filter and press Input to see your selection. For example, to find a function to calculate the number of days, type to dawn as a search term. The two possible results are the DAYS and NETWORKDAYS functions.
Or go to the Google Sheets dashboard, select Functions and then select the submenu at the bottom of the list.
Some functions require data to be entered in a certain way. Here’s how to do this, using the NETWORKDAYS function as an example.
Select the cell in which you want to display the number of working days between two dates.
Enter = NETWORK DAYS †
To use this function, you can start with an empty table.
Two options are displayed: NETWORKDAYS and NETWORKDAYS.INTL. Select NETWORKS †
The correct format used to enter the function is displayed. Check it out and then select X Leave.
Enter the start and end dates for the date range using the same format as in the formula. Pay special attention to punctuation.
Click Enter †
The number of working days is displayed in the selected cell.
Using functions with text in Google Sheets
Google Sheets features can also be useful when working with text. For example, the GOOGLETRANSLATE function translates the selected text from the source language into another specified language.
Here’s how to do it, using the Spanish word as an example Hello †
Select the cell where you want to display the translated text.
Enter = GOOGLETTRANSLATE(“HOLA”)
Click Enter †
The translation appears in the selected cell.