PrecisionCalc
xl
Precision

Data Control & Analysis Features

In addition to high precision, xlPrecision offers many data control, analysis, and other features:

Excluder Functions

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.

Miscellaneous Functions

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.

Miscellaneous Arguments

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.