Documentation/Calc Functions/RAWSUBTRACT

From The Document Foundation Wiki
Jump to: navigation, search
Other languages:
English

Function name:

RAWSUBTRACT

Category:

Mathematical

Summary:

Subtracts a set of numbers and gives the result without eliminating small roundoff errors.

Im-jabber.svg

Note:
This function is available since LibreOfficeDev 5.2.

Syntax:

RAWSUBTRACT(Minuend; Subtrahend 1[; Subtrahend 2][; … ;[ Subtrahend 254]])

Returns:

Subtracts the subtrahend(s) from the Minuend without eliminating roundoff errors and returns a real number.

Arguments:

Minuend(required) is a real number or a reference to a cell containing that number from which numbers are to be subtracted.

Subtrahend 1[; Subtrahend 2][; ... ;[ Subtrahend 254]] are real numbers or references to cells containing that numbers which will be subtracted from Minuend. At least one subtrahend is required.

The function should be called with at least two parameters.

Additional details:

None

Examples:

Formula Description Returns
=RAWSUBTRACT(0.987654321098765;0.9876543210987) difference between two numbers 6.50590692430342E-14
=RAWSUBTRACT(6.50590692430342) at least 2 arguments required so function returns an error value Err:511

Related LibreOffice functions:

SUM

ODF standard:

None

Equivalent Excel functions:

None