Home / Formula Types / Google

What is a GOOGLE formula in a spreadsheet?

The term 'Google' in this context refers to Google Sheets, a cloud-based spreadsheet software. Google Sheets offers a range of formulas and functions for data manipulation, calculations, and analysis. It provides similar functionalities to Microsoft Excel.

GOOGLE formula usage examples.

ARRAYFORMULA

The ARRAYFORMULA function enables the display of values returned from an array formula into multiple rows and/or columns and the use of non-array functions with arrays. It allows you to apply a formula to an entire range of cells, instead of having to manually enter the formula in each cell.

DETECTLANGUAGE

The DETECTLANGUAGE function is used to identify the language used in text within the specified range. It returns a two-letter language code that represents the detected language. This function is useful for analyzing multilingual data or for language-specific processing.

GOOGLEFINANCE

The GOOGLEFINANCE function is used to retrieve current or historical securities information from Google Finance. It allows you to fetch various attributes such as stock prices, volume, market cap, and more for a specific ticker symbol. You can specify the start and end dates, or the number of days, to fetch the data. Additionally, you can specify the interval (e.g., daily, weekly, monthly) for the data points.

GOOGLETRANSLATE

The GOOGLETRANSLATE function is used to translate text from one language to another. It takes three arguments: the text to be translated, the source language, and the target language. The source language and target language are optional parameters. If not specified, the function will attempt to detect the source language and translate to the default target language.

The IMAGE function is used to insert an image into a cell in Microsoft Excel. It takes the URL of the image as the first argument and optional arguments for mode, height, and width. The mode argument determines how the image is resized and positioned within the cell. The height and width arguments specify the desired dimensions of the image.

The QUERY function allows you to run a Google Visualization API Query Language query across data. It retrieves data from a specified range or table and returns the results based on the provided query criteria. The function supports various query operations, such as filtering, sorting, and selecting specific columns. The optional 'headers' parameter indicates whether the data range includes headers.

SPARKLINE

The SPARKLINE function is used to create a miniature chart contained within a single cell. It takes a range of data as input and allows for various chart types and options to be specified.

We use cookies on our site.