Text Documents (Writer)
HTML Documents (Writer Web)
Spreadsheets (Calc)
Presentations (Impress)
Drawings (Draw)
Database Functionality (Base)
Formulae (Math)
Charts and Diagrams
Macros and Scripting
Office Installation
Common Help Topics
OneOffice Logo

RAWSUBTRACT

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

Syntax

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

Minuend is a number or a reference to a cell containing a number.

Subtrahend 1[; Subtrahend 2][; ... ;[ Subtrahend 254]] are numbers or references to cells containing numbers.

The function should be called with at least two parameters.

RAWSUBTRACT() processes arguments from left to right. For example, RAWSUBTRACT(1;2;3;4) calculates 1-2-3-4 or ((1-2)-3)-4 in "natural" order.

Example

=RAWSUBTRACT(0.987654321098765, 0.9876543210987) returns 6.53921361504217E-14

=RAWSUBTRACT(0.987654321098765) returns Err:511 (Missing variable) because RAWSUBTRACT requires a minimum of two numbers.

Technical information

This function is available since Office 5.2.

This function is not part of the Open Document Format for Office Applications (OpenDocument) Version 1.3. Part 4: Recalculated Formula (OpenFormula) Format standard. The name space is

ORG.LIBREOFFICE.RAWSUBTRACT