*
PrecisionCalc*
Precision

xl

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