Excel - functions
The following Excel functions are currently supported by ExcelToGenesis
.
Operator | Example |
---|---|
Parenthesis | (A + B) * C |
Unary Minus | -A |
Unary Plus | +A |
Divide | A / B |
Multiple | A * B |
Add | A + B |
Minus | A – B |
Equal | A = B |
Not Equal | A <\> B |
Less Than | A < B |
Less than or equal | A <= B |
Greater Than | A > B |
Greater than or equal | A >= B |
Power | A^B |
Absolute | ABS(A) |
Percent | A% |
Concatenation | CONCAT(A, B) |
Min | MIN(A, B) |
Max (currently not supported) | MAX(A,B) |
If | IF(A, B, C) |
AND | AND(A, B) |
RoundDown | ROUNDDOWN(A, 2), ROUNDDOWN(A) |
Search | SEARCH(A, “Hello”) |
Is Error | ISERR(A) |