NEG (negative value)

<< Click to Display Table of Contents >>

NEG (negative value)

Syntax:

NEG(Number)

Description:

Return the negative value of Number.

Example:

NEG(42) returns -42

NEG(-42) returns 42

NEG(0) returns 0

Compatibility notes:

This function is not supported by Microsoft Excel. If you save a document in Excel format, all calculations using this function will be replaced by their last result as a fixed value.

Instead of using NEG, you can simply multiply the value by -1: NEG(x) equals (-1) * x.

See also:

ABS, SIGN