Skip to main content
Version: Previous

Excel - functions

The following Excel functions are currently supported by ExcelToGenesis.

OperatorExample
Parenthesis(A + B) * C
Unary Minus-A
Unary Plus+A
DivideA / B
MultipleA * B
AddA + B
MinusA – B
EqualA = B
Not EqualA <\> B
Less ThanA < B
Less than or equalA <= B
Greater ThanA > B
Greater than or equalA >= B
PowerA^B
AbsoluteABS(A)
PercentA%
ConcatenationCONCAT(A, B)
MinMIN(A, B)
Max (currently not supported)MAX(A,B)
IfIF(A, B, C)
ANDAND(A, B)
RoundDownROUNDDOWN(A, 2), ROUNDDOWN(A)
SearchSEARCH(A, “Hello”)
Is ErrorISERR(A)