# What is a OPERATOR formula in a spreadsheet?

Operator formulas and functions utilize basic mathematical operators (+, -, *, /) for arithmetic operations. They allow you to perform calculations using these operators to manipulate numerical values.

## OPERATOR formula usage examples.

The CONCAT function is used to concatenate multiple strings into a single string. It takes two or more arguments and returns the concatenation of those arguments. The function is equivalent to using the `&` operator in Excel. The CONCAT function is useful for combining text values, such as names or addresses, into a single cell.

The NE function is used to compare two values and returns TRUE if they are not equal, and FALSE otherwise. It is equivalent to the <> operator in Excel. The function takes two arguments: value1 and value2. If value1 and value2 are not equal, the function returns TRUE. If they are equal, the function returns FALSE.

The UNIQUE function is used to return unique rows or values from a given range. It discards any duplicates and returns the unique entries in the order in which they first appear in the source range. The function takes three arguments: 'range' specifies the range of cells to evaluate, 'by_column' is an optional argument that determines whether the uniqueness is evaluated by column (TRUE) or by row (FALSE), and 'exactly_once' is an optional argument that specifies whether to include only values that appear exactly once (TRUE) or all unique values (FALSE).