Expression
Enter your expression here. See below for a list of allowed expressions.
Result
The result will be printed here after you click the button Calculate.
Calculate
Calculates the expression without leaving the dialog.
Close
Closes this dialog box without performing any further action.
Help
Shows this help text.
Examples
Expression |
Result |
sqr(4) |
2 |
exp(1) |
2.7182818284591 |
log(10) |
2.302585092994 |
atn(1)*4 |
3.1415926535898 |
sin((355/113)/4)^2 |
0.50000008146034 |
sgn(-5) |
-1 |
Allowed expressions:
( ) parenthesis
+ add
- subtract
* multiply
/ divide
sqr() square root
^ power
log() natural logarithm
exp() euler’s number to the power of the argument
sin(), cos(), tan() sine, cosine, tangent (taking rad as argument)
asin(), acos(), atn() arc sine, arc cosine, arc tangent (giving rad as return value)
asinD(), acosD(), atnD() arc sine, arc cosine, arc tangent (giving degrees as return value)
sgn() sign function
For more detailed information see VBA Macro Language Overview.
See also