Written by Calculates the weighted average for a group of values, utilizing both the values and their associated weights.
Calculates the average numerical value from a set of data while disregarding any text values present.
Transforms a given number into its dollar representation.
Returns a specified number without any alterations.
Returns distinct rows from the specified source range while omitting duplicates. The order of rows in the result reflects their initial appearance in the source range.
Returns a value treated as a percentage; for example, `UNARY_PERCENT(100)` evaluates to `1`.
Provides a numerical value with the sign inverted.
Calculates a number raised to a specified exponent.
Returns `TRUE` when two specified values differ and `FALSE` when they are the same. This function is equivalent to using the `<>` operator.
Returns `TRUE` if the first argument is less than or equal to the second argument, and `FALSE` otherwise. This is the same as using the `<=` operator.