The Sheets application, which can be accessed with a Google account, has a functions menu listing formulas commonly used in different fields. This menu contains not only commonly used formulas, but also options for filtering and activating various functions. For example, while addition, multiplication and interest calculation functions can be used in a specific cell with Google Sheets; Options such as “GOOGLETRANSLATE” can be used to translate written data. Therefore, the formulas within the Google Sheets functions menu should be discussed in detail and how one of these functions is implemented should be illustrated.
What are Google Spreadsheet formulas?
The web-based spreadsheet application called Google Sheets has many formula functions. Thanks to these formulas, operations such as addition, multiplication, averaging, and sorting from largest to smallest can be performed with the data entered in the cells. When the Google Spreadsheets function list is examined, it is seen that there are a wide variety of formulas in this system that appeal to the fields of finance, mathematics, software and computers.
These formulas can be used to calculate data in different rows and columns after entering the “=” sign in an empty table cell. However, when applying a formula to cells in a certain range, simply click on the functions button at the top right of the Google Sheets file. The function options available in the Google Sheets mathematical formulas list accessed here are exemplified in the list below:
- COUNT ROWS, COUNT, VLOOKUP
- MATCH, COLUMN, HLOOKUP
- CONVERT, IF EMPTY, MULTIPLY
- TREND, FREQUENCY, VALUE
- VALUE, MATURITY, INTEREST RATE, AMOUNT OF INTEREST
- RETURN, COUPON, DISCOUNT
- NOMINAL, INTERNAL RATE OF RETURN, PAYMENT
- MSURE, GOOGLETRANSLATE, IMAGE
- BETADAĞ, BİNOMDAĞ, DISTORTION
- MIN, SMALL, PROBABILITY
- COUNTBLANK, SUMIFS, PRODUCT
- TOLL, BAĞDEĞSAY, MAK
What are the Google Sheets functional categories?
It can be seen that the function menu offered to users by Google Sheets consists of subcategories. If you click on the Functions button, the most used formulas are listed at the top of the categories. The categories in which Google Sheets functions are grouped to serve different areas are as follows:
- All
- Call
- parser
- Information
- Soap opera
- Filter
- Financial
- Logical
- Maths
- Text
- Engineering
- Operator
- History
- database
- web
- Statistical
How to add in Spreadsheet?
There are multiple methods for performing additions in Google Sheets. The first of these is completed by clicking on an empty cell and then selecting the “SUM” option from the list of functions. After choosing the formula, it must be determined in which range or cells the data will be calculated.
If all data in a certain range is to be collected, all cells should be selected with the cursor and the “enter” button should be clicked. Even if only the data in certain cells will be collected, the “SUM” function should be selected and the relevant values should be selected sequentially while adding an addition sign and finally pressing the “enter” button. Another practical method that can be used when collecting via Google Sheets can be completed with the following steps:
- First, the “=” sign must be pressed in an empty cell.
- Then, click on the cell containing one of the values to be collected.
- Before selecting another value, a “+” sign must be added.
- By completing these steps respectively, cell values in different rows and columns can be added to the process.
- When all values are selected, the formula result can be accessed by simply clicking the “enter” button.