# Sheets formulas

You can use embedded formulas in Mavibot sheets cells:

<div data-with-frame="true"><figure><img src="/files/3nXNXW6HxhgULpe2gbMI" alt=""><figcaption></figcaption></figure></div>

To use the formula, write "=" in the cell, then add (WITHOUT a space) the necessary formula in the form of a letter value (for example, SUMS) and select values from other cells or enter the values manually.

Basic symbols:

1. `=` — equal sign; to activate formulas, it is written the first character in the cell;
2. `SUM` — formula example (it can be any other formula from the table below);
3. `()` — values used in mathematical expressions are placed inside parentheses;
4. **`,`** — to specify the cells order, actions, or values in a formula;
5. **`:`** — Used to define a range of cells instead of specifying each cell separately.

<div data-with-frame="true"><figure><img src="/files/gcAnD2eBrpd7VJ4GKP19" alt="" width="440"><figcaption></figcaption></figure></div>

<div data-with-frame="true"><figure><img src="/files/BKXe6mVxSAyCcHzrh4XD" alt="" width="375"><figcaption></figcaption></figure></div>

Available formulas:

<table><thead><tr><th width="184.51171875">Formula</th><th width="297.80078125">Value</th><th>Example</th></tr></thead><tbody><tr><td><code>IF</code></td><td>Conditional logic</td><td><code>=IF(A1>0,"Plus","Minus")</code></td></tr><tr><td><code>AND</code></td><td>All conditions are true</td><td><code>=AND(A1>0,B1&#x3C;10)</code></td></tr><tr><td><code>OR</code></td><td>One of the conditions is true</td><td><code>=OR(A1>0,B1&#x3C;10)</code></td></tr><tr><td><code>NOT</code></td><td>Logical negation</td><td><code>=NOT(A1=0)</code></td></tr><tr><td><code>IFERROR</code></td><td>Return a value if an error occurs</td><td><code>=IFERROR(A1/B1,"Error")</code></td></tr><tr><td><code>ISNUMBER</code></td><td>Checks if the value is a number</td><td><code>=ISNUMBER(A1)</code></td></tr><tr><td><code>ISBLANK</code></td><td>Checks if the cell is blank</td><td><code>=ISBLANK(A1)</code></td></tr><tr><td><code>ISTEXT</code></td><td>Checks if the value is text</td><td><code>=ISTEXT(A1)</code></td></tr><tr><td><code>SUM</code></td><td>Sums a range</td><td><code>=SUM(A1:A5)</code></td></tr><tr><td><code>AVERAGE</code></td><td>Average</td><td><code>=AVERAGE(A1:A5)</code></td></tr><tr><td><code>MIN</code></td><td>Minimum</td><td><code>=MIN(A1:A5)</code></td></tr><tr><td><code>MAX</code></td><td>Maximum</td><td><code>=MAX(A1:A5)</code></td></tr><tr><td><code>ROUND</code></td><td>Round to N digits</td><td><code>=ROUND(A1,2)</code></td></tr><tr><td><code>ROUNDUP</code></td><td>Round up</td><td><code>=ROUNDUP(A1,2)</code></td></tr><tr><td><code>ROUNDDOWN</code></td><td>Round down</td><td><code>=ROUNDDOWN(A1,2)</code></td></tr><tr><td><code>INT</code></td><td>Integer part of the number.</td><td><code>=INT(A1)</code></td></tr><tr><td><code>MOD</code></td><td>Division remainder</td><td><code>=MOD(A1,3)</code></td></tr><tr><td><code>ABS</code></td><td>Absolute value (modulus)</td><td><code>=ABS(A1)</code></td></tr><tr><td><code>LEFT</code></td><td>Left character</td><td><code>=LEFT(A1,3)</code></td></tr><tr><td><code>RIGHT</code></td><td>Right character</td><td><code>=RIGHT(A1,2)</code></td></tr><tr><td><code>MID</code></td><td>Characters from the middle string</td><td><code>=MID(A1,2,3)</code></td></tr><tr><td><code>LEN</code></td><td> String length</td><td><code>=LEN(A1)</code></td></tr><tr><td><code>TEXT</code></td><td>Formats number as a text</td><td><code>=TEXT(A1,"0,00 ₽")</code></td></tr><tr><td><code>CONCAT</code></td><td>Concatenates strings</td><td><code>=CONCAT(A1,B1)</code></td></tr><tr><td><code>TEXTJOIN</code></td><td>Concatenates with a delimiter</td><td><code>=TEXTJOIN(" ",TRUE,A1:C1)</code></td></tr><tr><td><code>TRIM</code></td><td>Trims extra spaces</td><td><code>=TRIM(A1)</code></td></tr><tr><td><code>TODAY</code></td><td>Current date</td><td><code>=TODAY()</code></td></tr><tr><td><code>NOW</code></td><td>Time and date</td><td><code>=NOW()</code></td></tr><tr><td><code>DATE</code></td><td>Create date</td><td><code>=DATE(2025,5,14)</code></td></tr><tr><td><code>DAY</code></td><td>Extracts the day</td><td><code>=DAY(A1)</code></td></tr><tr><td><code>MONTH</code></td><td>Extracts the month</td><td><code>=MONTH(A1)</code></td></tr><tr><td><code>YEAR</code></td><td>Extracts the year</td><td><code>=YEAR(A1)</code></td></tr><tr><td><code>EDATE</code></td><td>Shifts the date by n months</td><td><code>=EDATE(A1,2)</code></td></tr><tr><td><code>DATEDIF</code></td><td>Difference between dates</td><td>=<code>DATEDIF(A1,B1,"м")</code></td></tr><tr><td><code>WEEKDAY</code></td><td>Day of the week</td><td><code>=WEEKDAY(A1,2)</code></td></tr><tr><td> <code>HOUR</code></td><td>Extracts hour from the time</td><td><code>=</code> <code>HOUR(A1)</code></td></tr><tr><td><code>MINUTE</code></td><td>Extracts minutes from the time</td><td><code>=MINUTE(A1)</code></td></tr><tr><td><code>SECOND</code></td><td>Extracts seconds from the time</td><td><code>=SECOND(A1)</code></td></tr><tr><td><code>COUNT</code></td><td>Counts numeric values</td><td><code>=COUNT(A1:A10)</code></td></tr><tr><td><code>COUNTA</code></td><td>Counts non-empty cells</td><td><code>=COUNTA(A1:A10)</code></td></tr><tr><td><code>COUNTBLANK</code></td><td>Counts blank cells</td><td><code>=COUNTBLANK(A1:A10)</code></td></tr><tr><td><code>COUNTIF</code></td><td>Count of values matching the condition</td><td><code>=COUNTIF(A1:A10,">5")</code></td></tr><tr><td><code>SUMIF</code></td><td>Conditional sum</td><td><code>=SUMIF(A1:A10,">5")</code></td></tr><tr><td><code>AVERAGEIF</code></td><td>Conditional average</td><td><code>=AVERAGEIF(A1:A10,">5")</code></td></tr></tbody></table>


---

# 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://docs.mavibot.ai/sheets/formulas.md?ask=<question>
```

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.