# How to Create a Custom Math Formula
*Skill Level: Intermediate*
## Before You Begin
* Should have knowledge about [Databases](https://help.adalo.com/database)
* Should have knowledge of [Magic Text](https://help.adalo.com/component-basics/inserting-dynamic-text)
## Walkthrough
#### **Using Custom Formulas with Magic Text**
When adding Magic Text, you’ll notice the option **"New Formula..."** at the bottom of the menu. Selecting this will insert a "Custom Formula" chip into your text box. Follow these steps to use the formula:
1. **Click on the "Custom Formula" chip** to open the formula editor.
2. In the editor, you can type any number along with the following operators:
* `+` for addition
* `-` for subtraction
* `/` for division
* `*` or `x` for multiplication
* `( )` for parentheses to group parts of the formula
3. **Insert Magic Numbers**:
* Click the **Magic Number icon** to insert a number from your database.
* Magic Numbers use Number properties from your data, and you can filter them by [**Counts**, **Sums**, **Averages**,](https://help.adalo.com/component-basics/inserting-dynamic-text/connecting-your-database-for-counts-and-aggregating) etc., of related collections.
4. **Insert Functions**:
* The Magic Number icon also allows you to insert functions into your formulas. The following functions are supported:
**Supported Functions**
* **Round**: Rounds a number to the nearest integer.
```plaintext
ROUND(4.32) → 4
ROUND(4.5) → 5
```
* **Integer (INT)**: Removes the decimals from a number (rounding down).
```plaintext
INT(4.32) → 4
INT(4.999) → 4
```
* **Absolute Value (ABS)**: Displays the absolute (positive) value of a number.
```plaintext
ABS(-4.32) → 4.32
```
* **Square Root (SQRT)**: Displays the square root of a number.
```plaintext
SQRT(9) → 3
```
* **Exponent (EXP)**: Raises one number to the power of another.
```plaintext
EXP(3, 2) → 9 (which is 3²)
```
* **Random Number (RAND)**: Generates a random number between two specified values.
```plaintext
RAND(0, 1) → A random number between 0 and 1
```
* **Logarithm (LOG)**: Displays the base 10 logarithm of a number.
```plaintext
LOG(100) → 2
```
***
#### **Example: Calculating Trip Cost Per Person**
Let’s say you want to calculate the cost of a trip per person using a custom math formula.
1. Insert a text box.
2. Select the **Magic Text** button (red accented letter).
3. Choose **"New Formula"** from the popup menu.
4. Click on the **pencil icon** to open the formula editor.
5. Click the **Magic Number icon** and select **Trip Cost**.
6. Enter `/` (to divide).
7. Click the **Magic Number icon** again and select **Group Size**.
8. You can also[ edit prefixes, suffixes, and formatting for custom formulas ](https://help.adalo.com/component-basics/inserting-dynamic-text/how-to-format-dates-and-numbers)as needed.
Now, your formula will divide the total trip cost by the group size.
### **Additional Tips**
* You can combine multiple Magic Numbers, operators, and functions in the same formula to create more complex calculations.
* Custom formulas are flexible—tailor them to your specific needs by adjusting the numbers or properties from your database. Check out some used by our Adalo Makers [Here](https://help.adalo.com/component-basics/inserting-dynamic-text/how-to-create-a-custom-math-formula/complex-calculations).
* Formulas using Dates will fail if MagicText is Null.
## Help
If you need additional help with this article, you can always ask in our [community forum](https://forum.adalo.com/)! Be sure to paste the link to this article in your post as well!
---
# Agent Instructions: Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.
Perform an HTTP GET request on the current page URL with the `ask` query parameter:
```
GET https://help.adalo.com/component-basics/inserting-dynamic-text/how-to-create-a-custom-math-formula.md?ask=
```
The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.
Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.
* Magic Numbers use Number properties from your data, and you can filter them by [**Counts**, **Sums**, **Averages**,](https://help.adalo.com/component-basics/inserting-dynamic-text/connecting-your-database-for-counts-and-aggregating) etc., of related collections.
4. **Insert Functions**:
* The Magic Number icon also allows you to insert functions into your formulas. The following functions are supported:
**Supported Functions**
* **Round**: Rounds a number to the nearest integer.
```plaintext
ROUND(4.32) → 4
ROUND(4.5) → 5
```
* **Integer (INT)**: Removes the decimals from a number (rounding down).
```plaintext
INT(4.32) → 4
INT(4.999) → 4
```
* **Absolute Value (ABS)**: Displays the absolute (positive) value of a number.
```plaintext
ABS(-4.32) → 4.32
```
* **Square Root (SQRT)**: Displays the square root of a number.
```plaintext
SQRT(9) → 3
```
* **Exponent (EXP)**: Raises one number to the power of another.
```plaintext
EXP(3, 2) → 9 (which is 3²)
```
* **Random Number (RAND)**: Generates a random number between two specified values.
```plaintext
RAND(0, 1) → A random number between 0 and 1
```
* **Logarithm (LOG)**: Displays the base 10 logarithm of a number.
```plaintext
LOG(100) → 2
```
***
#### **Example: Calculating Trip Cost Per Person**
Let’s say you want to calculate the cost of a trip per person using a custom math formula.
1. Insert a text box.
2. Select the **Magic Text** button (red accented letter).
3. Choose **"New Formula"** from the popup menu.
4. Click on the **pencil icon** to open the formula editor.
5. Click the **Magic Number icon** and select **Trip Cost**.
6. Enter `/` (to divide).
7. Click the **Magic Number icon** again and select **Group Size**.
8. You can also[ edit prefixes, suffixes, and formatting for custom formulas ](https://help.adalo.com/component-basics/inserting-dynamic-text/how-to-format-dates-and-numbers)as needed.