<< 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: