<< Click to Display Table of Contents >> NEG (negative value) |
Syntax:
NEG(Number)
Description:
This inverts the sign of a Number.
Example:
NEG(42) returns -42
NEG(-42) returns 42
NEG(0) returns 0
Compatibility notes:
This function does not exist in Microsoft Excel. If you save a document in Excel format, all calculations using this function will be replaced with their current result as a fixed value.
Instead of using NEG, you can simply multiply the value by -1: NEG(x) equals (-1) * x.
See also: