UMINUS function

PRO

The UMINUS function in Jspreadsheet Formulas Pro is a simple yet powerful tool that gives you the negative of a given number. Basically, it changes the sign of the number you input. For instance, if you use UMINUS on a positive number, it will return a negative number and vice versa. This function can be especially useful when you're dealing with financial data or any calculations that involve both gains and losses.

Documentation

Returns the negation of a number.

Syntax

UMINUS(number)

Parameter	Description
`number`	The number to be negated.

Behavior

The UMINUS function is used to reverse the sign of a given value. It is mostly used with numeric values. Here are some behaviors associated with this function:

For Numeric Values: The UMINUS function converts positive numbers to negative and vice versa.
For Empty Cells: If the UMINUS function is applied to an empty cell, it will return a 0.
For Text: Applying UMINUS to a cell containing text will result in a #VALUE! error, as the function is not designed to work with text.
For Booleans: If the UMINUS function is applied to a cell containing a boolean value, it will treat TRUE as 1 and FALSE as 0. Consequently, it will return -1 for TRUE and 0 for FALSE.
For Errors: If the cell to which the UMINUS function is applied contains an error, the function will return that same error.

Common Errors

Error	Description
`#VALUE!`	This error occurs when the `UMINUS` function is applied to a cell containing non-numeric values like text.

Best practices

Always ensure the cell to which the UMINUS function is applied contains a numeric value to avoid a #VALUE! error.

Use the UMINUS function with boolean values wisely. Remember that it treats TRUE as 1 and FALSE as 0.

Ensure the cell references used in the function are valid to prevent #REF! errors.

Double-check the function name for typos or incorrect syntax to avoid #NAME? errors.

Usage

A few examples using the UMINUS function.

UMINUS(5) returns -5  
UMINUS(-10) returns 10  
UMINUS(A1) returns the negation of the value in cell A1

Interactive Spreadsheet Demo

<html>
<script src="https://jspreadsheet.com/v11/jspreadsheet.js"></script>
<script src="https://jsuites.net/v5/jsuites.js"></script>
<link rel="stylesheet" href="https://jsuites.net/v5/jsuites.css" type="text/css" />
<link rel="stylesheet" href="https://jspreadsheet.com/v11/jspreadsheet.css" type="text/css" />

<link rel="stylesheet" href="https://fonts.googleapis.com/css?family=Material+Icons" />
<script src="https://cdn.jsdelivr.net/npm/@jspreadsheet/formula-pro/dist/index.min.js"></script>

<div id="spreadsheet"></div>

<script>
// Set your JSS license key (The following key only works for one day)
jspreadsheet.setLicense('ZjQ4ZmVjMzMwYzg0NTI4ODNkNTAxYTNiODk2NWExODliNzIzYjkyNGI3YWI0YTU3YzYzZTgyMGQ0Y2VhNWRlN2MzM2Q0YTkwOGEwYTY4NGY4YjU4Y2ViNjIwMzg0OGYwMGM1OWQ1YTZkOGI0M2M1NTc5MmFiZjVmMmM3MWFiODEsZXlKamJHbGxiblJKWkNJNklpSXNJbTVoYldVaU9pSktjM0J5WldGa2MyaGxaWFFpTENKa1lYUmxJam94TnpVNE56YzBNRFF5TENKa2IyMWhhVzRpT2xzaWFuTndjbVZoWkhOb1pXVjBMbU52YlNJc0ltTnZaR1Z6WVc1a1ltOTRMbWx2SWl3aWFuTm9aV3hzTG01bGRDSXNJbU56WWk1aGNIQWlMQ0p6ZEdGamEySnNhWFI2TG1sdklpd2lkMlZpWTI5dWRHRnBibVZ5TG1sdklpd2lkMlZpSWl3aWJHOWpZV3hvYjNOMElsMHNJbkJzWVc0aU9pSXpOQ0lzSW5OamIzQmxJanBiSW5ZM0lpd2lkamdpTENKMk9TSXNJbll4TUNJc0luWXhNU0lzSW1Ob1lYSjBjeUlzSW1admNtMXpJaXdpWm05eWJYVnNZU0lzSW5CaGNuTmxjaUlzSW5KbGJtUmxjaUlzSW1OdmJXMWxiblJ6SWl3aWFXMXdiM0owWlhJaUxDSmlZWElpTENKMllXeHBaR0YwYVc5dWN5SXNJbk5sWVhKamFDSXNJbkJ5YVc1MElpd2ljMmhsWlhSeklpd2lZMnhwWlc1MElpd2ljMlZ5ZG1WeUlpd2ljMmhoY0dWeklpd2labTl5YldGMElsMHNJbVJsYlc4aU9uUnlkV1Y5');

// Set the extensions
jspreadsheet.setExtensions({ formula });

// Create a new spreadsheet
jspreadsheet(document.getElementById('spreadsheet'), {
  worksheets: [{
    data: [
    [
        "Temperature (\u00b0C)",
        "Opposite Temperature",
        "Net Change"
    ],
    [
        25,
        "=UMINUS(A2)",
        "=UMINUS(C4)"
    ],
    [
        -15,
        "=UMINUS(A3)",
        8
    ],
    [
        0,
        "=UMINUS(A4)",
        -8
    ]
]
  }]
});
</script>
</html>

import React, { useRef } from "react";
import { Spreadsheet, Worksheet, jspreadsheet } from "@jspreadsheet/react";
import formula from "@jspreadsheet/formula-pro";
import "jsuites/dist/jsuites.css";
import "jspreadsheet/dist/jspreadsheet.css";

// Set license
jspreadsheet.setLicense('ZjQ4ZmVjMzMwYzg0NTI4ODNkNTAxYTNiODk2NWExODliNzIzYjkyNGI3YWI0YTU3YzYzZTgyMGQ0Y2VhNWRlN2MzM2Q0YTkwOGEwYTY4NGY4YjU4Y2ViNjIwMzg0OGYwMGM1OWQ1YTZkOGI0M2M1NTc5MmFiZjVmMmM3MWFiODEsZXlKamJHbGxiblJKWkNJNklpSXNJbTVoYldVaU9pSktjM0J5WldGa2MyaGxaWFFpTENKa1lYUmxJam94TnpVNE56YzBNRFF5TENKa2IyMWhhVzRpT2xzaWFuTndjbVZoWkhOb1pXVjBMbU52YlNJc0ltTnZaR1Z6WVc1a1ltOTRMbWx2SWl3aWFuTm9aV3hzTG01bGRDSXNJbU56WWk1aGNIQWlMQ0p6ZEdGamEySnNhWFI2TG1sdklpd2lkMlZpWTI5dWRHRnBibVZ5TG1sdklpd2lkMlZpSWl3aWJHOWpZV3hvYjNOMElsMHNJbkJzWVc0aU9pSXpOQ0lzSW5OamIzQmxJanBiSW5ZM0lpd2lkamdpTENKMk9TSXNJbll4TUNJc0luWXhNU0lzSW1Ob1lYSjBjeUlzSW1admNtMXpJaXdpWm05eWJYVnNZU0lzSW5CaGNuTmxjaUlzSW5KbGJtUmxjaUlzSW1OdmJXMWxiblJ6SWl3aWFXMXdiM0owWlhJaUxDSmlZWElpTENKMllXeHBaR0YwYVc5dWN5SXNJbk5sWVhKamFDSXNJbkJ5YVc1MElpd2ljMmhsWlhSeklpd2lZMnhwWlc1MElpd2ljMlZ5ZG1WeUlpd2ljMmhoY0dWeklpd2labTl5YldGMElsMHNJbVJsYlc4aU9uUnlkV1Y5');

// Set the extensions
jspreadsheet.setExtensions({ formula });

export default function App() {
    // Spreadsheet array of worksheets
    const spreadsheet = useRef();

    // Worksheet data
    const data = [
    [
        "Temperature (\u00b0C)",
        "Opposite Temperature",
        "Net Change"
    ],
    [
        25,
        "=UMINUS(A2)",
        "=UMINUS(C4)"
    ],
    [
        -15,
        "=UMINUS(A3)",
        8
    ],
    [
        0,
        "=UMINUS(A4)",
        -8
    ]
];

    // Render component
    return (
        <Spreadsheet ref={spreadsheet}>
            <Worksheet data={data} />
        </Spreadsheet>
    );
}

<template>
    <Spreadsheet ref="spreadsheet">
        <Worksheet :data="data" />
    </Spreadsheet>
</template>

<script>
import { Spreadsheet, Worksheet, jspreadsheet } from "@jspreadsheet/vue";
import "jsuites/dist/jsuites.css";
import "jspreadsheet/dist/jspreadsheet.css";
import formula from "@jspreadsheet/formula-pro";

// Set license
jspreadsheet.setLicense('ZjQ4ZmVjMzMwYzg0NTI4ODNkNTAxYTNiODk2NWExODliNzIzYjkyNGI3YWI0YTU3YzYzZTgyMGQ0Y2VhNWRlN2MzM2Q0YTkwOGEwYTY4NGY4YjU4Y2ViNjIwMzg0OGYwMGM1OWQ1YTZkOGI0M2M1NTc5MmFiZjVmMmM3MWFiODEsZXlKamJHbGxiblJKWkNJNklpSXNJbTVoYldVaU9pSktjM0J5WldGa2MyaGxaWFFpTENKa1lYUmxJam94TnpVNE56YzBNRFF5TENKa2IyMWhhVzRpT2xzaWFuTndjbVZoWkhOb1pXVjBMbU52YlNJc0ltTnZaR1Z6WVc1a1ltOTRMbWx2SWl3aWFuTm9aV3hzTG01bGRDSXNJbU56WWk1aGNIQWlMQ0p6ZEdGamEySnNhWFI2TG1sdklpd2lkMlZpWTI5dWRHRnBibVZ5TG1sdklpd2lkMlZpSWl3aWJHOWpZV3hvYjNOMElsMHNJbkJzWVc0aU9pSXpOQ0lzSW5OamIzQmxJanBiSW5ZM0lpd2lkamdpTENKMk9TSXNJbll4TUNJc0luWXhNU0lzSW1Ob1lYSjBjeUlzSW1admNtMXpJaXdpWm05eWJYVnNZU0lzSW5CaGNuTmxjaUlzSW5KbGJtUmxjaUlzSW1OdmJXMWxiblJ6SWl3aWFXMXdiM0owWlhJaUxDSmlZWElpTENKMllXeHBaR0YwYVc5dWN5SXNJbk5sWVhKamFDSXNJbkJ5YVc1MElpd2ljMmhsWlhSeklpd2lZMnhwWlc1MElpd2ljMlZ5ZG1WeUlpd2ljMmhoY0dWeklpd2labTl5YldGMElsMHNJbVJsYlc4aU9uUnlkV1Y5');

// Set the extensions
jspreadsheet.setExtensions({ formula });

export default {
    components: {
        Spreadsheet,
        Worksheet,
    },
    data() {
        // Worksheet data
        const data = [
    [
        "Temperature (\u00b0C)",
        "Opposite Temperature",
        "Net Change"
    ],
    [
        25,
        "=UMINUS(A2)",
        "=UMINUS(C4)"
    ],
    [
        -15,
        "=UMINUS(A3)",
        8
    ],
    [
        0,
        "=UMINUS(A4)",
        -8
    ]
]

        return {
            data
        };
    }
}
</script>

import { Component, ViewChild, ElementRef } from "@angular/core";
import jspreadsheet from "jspreadsheet";
import * as formula from "@jspreadsheet/formula-pro";

// Set your JSS license key (The following key only works for one day)
jspreadsheet.setLicense('ZjQ4ZmVjMzMwYzg0NTI4ODNkNTAxYTNiODk2NWExODliNzIzYjkyNGI3YWI0YTU3YzYzZTgyMGQ0Y2VhNWRlN2MzM2Q0YTkwOGEwYTY4NGY4YjU4Y2ViNjIwMzg0OGYwMGM1OWQ1YTZkOGI0M2M1NTc5MmFiZjVmMmM3MWFiODEsZXlKamJHbGxiblJKWkNJNklpSXNJbTVoYldVaU9pSktjM0J5WldGa2MyaGxaWFFpTENKa1lYUmxJam94TnpVNE56YzBNRFF5TENKa2IyMWhhVzRpT2xzaWFuTndjbVZoWkhOb1pXVjBMbU52YlNJc0ltTnZaR1Z6WVc1a1ltOTRMbWx2SWl3aWFuTm9aV3hzTG01bGRDSXNJbU56WWk1aGNIQWlMQ0p6ZEdGamEySnNhWFI2TG1sdklpd2lkMlZpWTI5dWRHRnBibVZ5TG1sdklpd2lkMlZpSWl3aWJHOWpZV3hvYjNOMElsMHNJbkJzWVc0aU9pSXpOQ0lzSW5OamIzQmxJanBiSW5ZM0lpd2lkamdpTENKMk9TSXNJbll4TUNJc0luWXhNU0lzSW1Ob1lYSjBjeUlzSW1admNtMXpJaXdpWm05eWJYVnNZU0lzSW5CaGNuTmxjaUlzSW5KbGJtUmxjaUlzSW1OdmJXMWxiblJ6SWl3aWFXMXdiM0owWlhJaUxDSmlZWElpTENKMllXeHBaR0YwYVc5dWN5SXNJbk5sWVhKamFDSXNJbkJ5YVc1MElpd2ljMmhsWlhSeklpd2lZMnhwWlc1MElpd2ljMlZ5ZG1WeUlpd2ljMmhoY0dWeklpd2labTl5YldGMElsMHNJbVJsYlc4aU9uUnlkV1Y5');

// Set the extensions
jspreadsheet.setExtensions({ formula });

@Component({
    standalone: true,
    selector: "app-root",
    template: `<div #spreadsheet></div>`
})
export class AppComponent {
    @ViewChild("spreadsheet") spreadsheet: ElementRef;
    // Worksheets
    worksheets: jspreadsheet.worksheetInstance[];

    // Create a new data grid
    ngAfterViewInit() {
        // Create spreadsheet
        this.worksheets = jspreadsheet(this.spreadsheet.nativeElement, {
            worksheets: [{
                data: [
    [
        "Temperature (\u00b0C)",
        "Opposite Temperature",
        "Net Change"
    ],
    [
        25,
        "=UMINUS(A2)",
        "=UMINUS(C4)"
    ],
    [
        -15,
        "=UMINUS(A3)",
        8
    ],
    [
        0,
        "=UMINUS(A4)",
        -8
    ]
]
            }]
        });
    }
}

Edit this page on GitHub