In Google Sheets, a function is a formula that performs a specific calculation or action on a given set of data. Functions can be used to perform a wide variety of tasks, from simple arithmetic operations to complex financial calculations. By default, functions in Google Sheets are limited to a single line of text. However, it is possible to create functions that span multiple lines by using the `JOIN` function.
The `JOIN` function concatenates multiple text strings into a single string. It can be used to combine the results of multiple functions, or to create a multi-line function. For example, the following function returns the current date and time on two separate lines:
