Table formulas

You can use embedded formulas in Mavibot table 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:

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.

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")