# Abs, Exp, Ln, Power, Log, and Sqrt functions in Power Apps

Calculates absolute values, 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's equivalent to using the **^** operator.

The **Log** function returns the logarithm of its first argument in the base specified by its second argument (or 10 if not specified).

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 in a **Value** column, 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*. Which can happen 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.

**Log**( *Number*, *Base* )

*Number*- Required. Number to calculate the logarithm.*Base*- Optional. The base of the logarithm to calculate. By default, 10 (when not specified).

**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... |

Log( 100 ) |
Returns the logarithm in base 10 of the number 100. | 2 |

Log( 64, 2 ) |
Returns the logarithm in base 2 of the number 64. | 6 |

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:

Value |
---|

9 |

-4 |

2 |

Formula | Description | Result |
---|---|---|

Abs( ValueTable ) |
Returns the absolute value of each number in the table. | A single-column table with a `Value` column containing the following values: 9, 4, 2 |

Exp( ValueTable ) |
Returns e raised to the power of each number in the table. |
A single-column table with a `Value` column containing the following values: 8103.083927..., 0.018315..., 7.389056... |

Ln( ValueTable ) |
Returns the natural logarithm of each number in the table. | A single-column table with a `Value` column containing the following values: 2.197224..., Blank(), 0.693147... |

Sqrt( ValueTable ) |
Returns the square root of each number in the table | A single-column table with a `Value` column containing the following values: 3, Blank(), 1.414213... |

### 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.

## Feedback

Submit and view feedback for