Releases: ECP-Solutions/VBA-Expressions
Releases · ECP-Solutions/VBA-Expressions
VBA-Expressions v0.0.1
Advantages
- Easy to use and integrate.
- Basic math operators:
+
-
*
/
\
^
!
- Logical expressions:
& (AND)
| (OR)
|| (XOR)
- Binary relations:
< <= <> >= = >
- More than 20 built-in functions:
Max
,Min
,Avg
,Sin
,Ceil
,Floor
... - Very flexible: variables, constants and user-defined functions (UDFs) support.
- Implied multiplication for variables, constants and functions:
5avg(2;abs(-3-7tan(5));9)-12pi-e+(7/sin(30)-4!)*min(cos(30);cos(150))
is valid expression;5(2)
is not. - Evaluation of arrays of expressions given as text strings, as in Java: curly brackets must be used to define arrays
{{...};{...}}
- Floating point notation input support:
-5E-5
,(1.434E3+1000)*2/3.235E-5
are valid inputs. - Free of external VBA dependencies: does not use dll.