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:

 

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.

 

 

xlPrecision Home Page
PrecisionCalc Home Page