PrecisionCalc
xl
Precision
Get Your Numbers Right
Data Control & Analysis Features
In addition to high precision, xlPrecision offers many data control, analysis, and other features:
xlPrecision's Excluder functions have no equivalents in Excel:
xlpEXCLUDE
Excludes undesired characters and/or digits from a number
or text.
xlpEXCLUDENOTNUM
Excludes non-numeric and other undesired characters and/or digits from a number
or text.
xlpEXTRACT
Extracts desired characters and/or digits from a number or
text.
xlpEXTRACTNUM
Extracts numeric and other desired characters from a
number or text.
These xlPrecision functions have no equivalents in Excel:
xlpEVEN2
Rounds down to the
next even integer, instead of rounding up like xlpEVEN.
xlpFRAC
Returns the
fractional portion of a decimal non-integer. Not to be confused with
xlpMOD.
xlpGCD2
Accepts negative
numbers, does not truncate non-integers, and can return certain non-integers.
xlpLCM2
Does not truncate
non-integers, and can return certain non-integers.
xlpMODTRUNC
Same as xlpMOD,
but uses xlpTRUNC internally instead of xlpINT.
xlpODD2
Rounds down to the
next even integer, instead of rounding up like xlpODD.
xlpREDUCEFRACTION
Returns a string formatted as
<numerator>/<denominator>, and the character used to
separate the numerator and denominator ("/" by default) can be customized. Can
also simplify the reduced fraction by multiplying numerator and denominator by
factors of 10 until both are integers. The simplified fraction is then reduced
as much as possible, though the result may not be a reduction relative to the
original fraction. Can also return reduced numerator, reduced divisor, divisor used
for reduction, or all of these in an array.
Certain other xlPrecision functions offer arguments that let you go beyond the functionality offered by the equivalent low-precision Excel function or feature:
xlpEVEN
round_neg_toward_zero argument allows
rounding negatives toward zero.
xlpMOD
sign argument
offers 5 choices for determining sign of result.
xlpODD
round_neg_toward_zero argument allows rounding negatives toward zero.
xlpSORT
Can sort top to
bottom or left to right, sort down multiple rows or across multiple columns, and
either retain the number of rows and columns of the source range or sort into a
different selected number of rows and columns.
xlPrecision
Home Page
PrecisionCalc Home Page