Calculates absolute values, natural logarithms, square roots, and the results of raising *e* or any number to specified powers.

## Description

The **Abs** function returns the non-negative value of its argument. If a number is negative, **Abs** returns the positive equivalent.

The **Exp** function returns *e* raised to the power of its argument. The transcendental number *e* begins 2.7182818...

The **Ln** function returns the natural logarithm (base *e*) of its argument.

The **Power** function returns a number raised to a power. It is equivalent to using the **^** operator.

The **Sqrt** function returns the number that, when multiplied by itself, equals its argument.

If you pass a single number, the return value is a single result based on the function called. If you pass a single-column table that contains numbers, the return value is a single-column table of results, one result for each record in the argument's table. If you have a multi-column table, you can shape it into a single-column table, as working with tables describes.

If an argument would result in an undefined valued, the result is *blank*. This can happen, for example, with square roots and logarithms of negative numbers.

## Syntax

**Abs**( *Number* )**Exp**( *Number* )**Ln**( *Number* )**Sqrt**( *Number* )

*Number*- Required. Number to operate on.

**Power**( *Base*, *Exponent* )

*Base*- Required. Base number to raise.*Exponent*- Required. The exponent to which the base number is raised.

**Abs**( *SingleColumnTable* )**Exp**( *SingleColumnTable* )**Ln**( *SingleColumnTable* )**Sqrt**( *SingleColumnTable* )

*SingleColumnTable*- Required. A single-column table of numbers to operate on.

## Examples

### Single number

Formula | Description | Result |

Abs( -55 ) | Returns the number without the negative sign. | 55 |

Exp( 2 ) | Returns e raised to the power of 2, or e * e. | 7.389056... |

Ln( 100 ) | Returns the natural logarithm (base e) of the number 100. | 4.605170... |

Power( 5, 3 ) | Returns 5 raised to the power of 3, or 5 * 5 * 5. | 125 |

Sqrt( 9 ) | Returns the number that, when multiplied by itself, results in 9. | 3 |

### Single-column table

The examples in this section use a data source that's named **ValueTable** and that contains this data:

Formula | Description | Result |

Abs( ValueTable ) | Returns the absolute value of each number in the table. | |

Exp( ValueTable ) | Returns e raised to the power of each number in the table. | |

Ln( ValueTable ) | Returns the natural logarithm of each number in the table. | |

Sqrt( ValueTable ) | Returns the square root of each number in the table |

### Step-by-step example

Add a

**Text input**control, and name it**Source**.Add a

**Label**control, and set its**Text**property to this formula:

**Sqrt( Value( Source.Text ) )**Type a number into

**Source**, and confirm that the**Label**control shows the square root of the number that you typed.