Model 4200A-SCS Parameter Analyzer Reference Manual
Section 6: Clarius
4200A-901-01 Rev. C / February 2017
6-279
EXP Calc worksheet function
This command returns the constant e raised to the specified power.
Usage
EXP(
Value
)
Value
Any number as the exponent
Details
The constant e is 2.71828182845904 (the base of the natural logarithm).
Example
=EXP(2.5)
=EXP(3)
Returns
12.1824E+0
.
Returns
20.0855E+0
.
Also see
(on page 6-281)
(on page 6-281)
FIXED Calc worksheet function
This command rounds a number to the supplied precision, formats the number in decimal format, and returns the
result as text.
Usage
FIXED(
Value
)
FIXED(
Value
,
Precision
)
FIXED(
Value
,
Precision
,
No_commas
)
Value
Any number
Precision
The number of digits that appear to the right of the decimal point; if this argument is
omitted, a default precision of 2 is used
No_commas
No_commas
determines if commas separate thousands in the result; send
1
to
exclude commas in the result; send
0
or do not define
No_commas
to include
separators
Details
If you specify negative
Precision
,
Value
is rounded to the left of the decimal point. You can
specify a precision up to 127 digits.
Example
=FIXED(2000.5, 3)
=FIXED(2009.5, -1,1)
=FIXED(2009.5, -1,0)
Returns
2,000.500
.
Returns
2010
.
Returns
2,010
.
Also see
(on page 6-290)