You can use embedded formulas in Mavibot sheets cells:
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:
-
=— equal sign; to activate formulas, it is written the first character in the cell; -
SUM— formula example (it can be any other formula from the table below); -
()— values used in mathematical expressions are placed inside parentheses; -
,— to specify the cells order, actions, or values in a formula; -
:— Used to define a range of cells instead of specifying each cell separately.
Available formulas:
| Formula | Value | Example |
|---|---|---|
IF |
Conditional logic | =IF(A1>0,"Plus","Minus") |
AND |
All conditions are true | =AND(A1>0,B1<10) |
OR |
One of the conditions is true | =OR(A1>0,B1<10) |
NOT |
Logical negation | =NOT(A1=0) |
IFERROR |
Return a value if an error occurs | =IFERROR(A1/B1,"Error") |
ISNUMBER |
Checks if the value is a number | =ISNUMBER(A1) |
ISBLANK |
Checks if the cell is blank | =ISBLANK(A1) |
ISTEXT |
Checks if the value is text | =ISTEXT(A1) |
SUM |
Sums a range | =SUM(A1:A5) |
AVERAGE |
Average | =AVERAGE(A1:A5) |
MIN |
Minimum | =MIN(A1:A5) |
MAX |
Maximum | =MAX(A1:A5) |
ROUND |
Round to N digits | =ROUND(A1,2) |
ROUNDUP |
Round up | =ROUNDUP(A1,2) |
ROUNDDOWN |
Round down | =ROUNDDOWN(A1,2) |
INT |
Integer part of the number. | =INT(A1) |
MOD |
Division remainder | =MOD(A1,3) |
ABS |
Absolute value (modulus) | =ABS(A1) |
LEFT |
Left character | =LEFT(A1,3) |
RIGHT |
Right character | =RIGHT(A1,2) |
MID |
Characters from the middle string | =MID(A1,2,3) |
LEN |
String length | =LEN(A1) |
TEXT |
Formats number as a text | =TEXT(A1,"0,00 ₽") |
CONCAT |
Concatenates strings | =CONCAT(A1,B1) |
TEXTJOIN |
Concatenates with a delimiter | =TEXTJOIN(" ",TRUE,A1:C1) |
TRIM |
Trims extra spaces | =TRIM(A1) |
TODAY |
Current date | =TODAY() |
NOW |
Time and date | =NOW() |
DATE |
Create date | =DATE(2025,5,14) |
DAY |
Extracts the day | =DAY(A1) |
MONTH |
Extracts the month | =MONTH(A1) |
YEAR |
Extracts the year | =YEAR(A1) |
EDATE |
Shifts the date by n months | =EDATE(A1,2) |
DATEDIF |
Difference between dates | =DATEDIF(A1,B1,"м")
|
WEEKDAY |
Day of the week | =WEEKDAY(A1,2) |
HOUR
|
Extracts hour from the time |
= HOUR(A1)
|
MINUTE |
Extracts minutes from the time | =MINUTE(A1) |
SECOND |
Extracts seconds from the time | =SECOND(A1) |
COUNT |
Counts numeric values | =COUNT(A1:A10) |
COUNTA |
Counts non-empty cells | =COUNTA(A1:A10) |
COUNTBLANK |
Counts blank cells | =COUNTBLANK(A1:A10) |
COUNTIF |
Count of values matching the condition | =COUNTIF(A1:A10,">5") |
SUMIF |
Conditional sum | =SUMIF(A1:A10,">5") |
AVERAGEIF |
Conditional average | =AVERAGEIF(A1:A10,">5") |