> For clean Markdown of any page, append .md to the page URL.
> For a complete documentation index, see https://help.sigmacomputing.com/llms.txt.
> For AI client integration (Claude Code, Cursor, etc.), connect to the MCP server at https://help.sigmacomputing.com/_mcp/server.

# Math functions

> Browse Sigma math functions available in formulas and calculations.

Math functions perform mathematical operations, including arithmetic, trigonometric, rounding, statistical, and logarithmic calculations.

| Function                             | Description                                                                                 |
| ------------------------------------ | ------------------------------------------------------------------------------------------- |
| [Abs](/docs/abs)                     | Returns the absolute value of a number.                                                     |
| [Acos](/docs/acos)                   | Returns the arccosine of an angle.                                                          |
| [Asin](/docs/asin)                   | Returns the arcsine of an angle.                                                            |
| [Atan](/docs/atan)                   | Returns the arctangent of an angle.                                                         |
| [Atan2](/docs/atan2)                 | Returns the arctangent of a coordinate pair.                                                |
| [BinFixed](/docs/binfixed)           | Calculates the bin of a value among the specified number of identically-sized bins.         |
| [BinRange](/docs/binrange)           | Calculates the bin for a value using the specified lower bounds.                            |
| [BitAnd](/docs/bitand)               | Calculates the bitwise `AND` of two numbers.                                                |
| [BitOr](/docs/bitor)                 | Calculates the bitwise `OR` of two numbers.                                                 |
| [Ceiling](/docs/ceiling)             | Rounds the number up to the closest multiple of equal or greater value.                     |
| [Cos](/docs/cos)                     | Returns the cosine of an angle.                                                             |
| [Cot](/docs/cot)                     | Returns the cotangent of an angle.                                                          |
| [Degrees](/docs/degrees)             | Converts the angle measurement from radians to degrees.                                     |
| [DistanceGlobe](/docs/distanceglobe) | Calculates the distance between two points on the globe, in kilometers.                     |
| [DistancePlane](/docs/distanceplane) | Calculates the distance between two points on a plane.                                      |
| [Div](/docs/div)                     | Returns the integer component of a division.                                                |
| [Exp](/docs/exp)                     | Returns the mathematical constant `e`, or `2.71828`.                                        |
| [Floor](/docs/floor)                 | Rounds the number down to the closest multiple of equal or lesser value.                    |
| [Greatest](/docs/greatest)           | Returns the largest value from a list.                                                      |
| [Int](/docs/int)                     | Rounds the integer down to the largest integer of lesser or equal value.                    |
| [IsEven](/docs/iseven)               | Returns True if the integer part of a number is even.                                       |
| [IsOdd](/docs/isodd)                 | Returns True if the integer part of a number is odd.                                        |
| [Least](/docs/least)                 | Returns the smallest value from a list.                                                     |
| [Ln](/docs/ln)                       | Calculates the natural logarithm of a number, `log_e(n)`.                                   |
| [Log](/docs/log)                     | Calculates the logarithm of a number. Defaults to `log_10(n)`.                              |
| [Mod](/docs/mod)                     | Returns the remainder component of a division.                                              |
| [MRound](/docs/mround)               | Rounds the number down to the closest multiple of the specified number.                     |
| [Pi](/docs/pi)                       | Returns the mathematical constant `π`, or `3.14159...`.                                     |
| [Power](/docs/power)                 | Calculates the result of a number raised to the specified power.                            |
| [Radians](/docs/radians)             | Converts the angle measurement from degrees to radians.                                     |
| [Round](/docs/round)                 | Calculates the number to the specified number of digits.                                    |
| [RoundDown](/docs/rounddown)         | Rounds a number down to the specified number of digits or decimal places.                   |
| [RoundUp](/docs/roundup)             | Rounds a number up to the specified number of digits or decimal places.                     |
| [RowAvg](/docs/rowavg)               | Calculates the average value of a list of numbers.                                          |
| [Sign](/docs/sign)                   | Calculates the sign of a number. Returns `-1` if negative, `1` if positive, or `0` if zero. |
| [Sin](/docs/sin)                     | Calculates the sine of an angle.                                                            |
| [Sqrt](/docs/sqrt)                   | Calculates the square root of a number.                                                     |
| [Tan](/docs/tan)                     | Calculates the tangent of an angle.                                                         |
| [Trunc](/docs/trunc)                 | Truncates a number to the specified number of digits or decimal places.                     |