EVEN function

PRO BASIC

The EVEN function in Jspreadsheet Formulas Pro is a useful tool that helps you round a number up to the nearest even integer. This means if the number is odd, the function will increase it by one to make it even. For instance, if you input 7, the function will output 8. This can be extremely helpful in various data analysis tasks where you need to work with even numbers.

Documentation

The EVEN function rounds a number up to the nearest even integer.

Syntax

EVEN(x)

Parameter	Description
`x`	The number to be rounded up to the nearest even integer.

Behavior

The EVEN function rounds a number up to the nearest even integer, away from zero for negative values. The function takes a single argument, which is the number you want to round up. If the number is already even, the function returns the same number. If the number is odd, the function adds one to make it even.

If the cell is empty, the 'EVEN' function treats it as 0.
If the cell contains a boolean value, TRUE is treated as 1 and becomes 2; FALSE is treated as 0 and stays 0.
If the cell contains a non-numeric text, the 'EVEN' function returns an error.
If the argument is a numeric text, the function converts it into a number and then performs the operation.
If the cell contains an error, the 'EVEN' function also returns an error.

Common Errors

Error	Description
#VALUE!	This error occurs when the given argument is non-numeric text.
#REF!	This error occurs when the given cell reference is not valid.

Best practices

Always ensure that the input value given to the 'EVEN' function is a numeric value to avoid the #VALUE! error.

Use valid cell references as arguments to avoid the #REF! error.

Check the spelling and syntax of the function name to avoid the #NAME? error.

Keep in mind that the 'EVEN' function always rounds up, so negative numbers are rounded away from zero to the next even number.

Usage

A few examples using the EVEN function.

EVEN(3.2)  
// Returns 4 (rounds up to the nearest even integer)  

EVEN(5)  
// Returns 6 (odd number increases by 1 to make it even)  

EVEN(-3.2)  
// Returns -4 (negative number rounded away from zero)  

EVEN(TRUE)  
// Returns 2 (TRUE → 1 → rounded to 2)  

EVEN(A2)  
// Rounds the value in cell A2 up to the nearest even integer

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('MDc5OWY1MDk2OGVmYzk0Yjc2NmFhMmU5NjI0OThlYWYyY2Q4MTNjZjFmNTkzYWJkNzExNjdhNjQ4YmIwOTM3NjY5YTYwZjdkMzM4ZWMyMmVlZDVjODJlNDk2NGIyZDE3Y2ZjNDEzOWNlYWU4OTk4NDg0ZTk2NDZiNDE0NTk0NDksZXlKamJHbGxiblJKWkNJNklpSXNJbTVoYldVaU9pSktjM0J5WldGa2MyaGxaWFFpTENKa1lYUmxJam94TnpVM01ETXhNRFF4TENKa2IyMWhhVzRpT2xzaWFuTndjbVZoWkhOb1pXVjBMbU52YlNJc0ltTnZaR1Z6WVc1a1ltOTRMbWx2SWl3aWFuTm9aV3hzTG01bGRDSXNJbU56WWk1aGNIQWlMQ0p6ZEdGamEySnNhWFI2TG1sdklpd2lkMlZpWTI5dWRHRnBibVZ5TG1sdklpd2lkMlZpSWl3aWJHOWpZV3hvYjNOMElsMHNJbkJzWVc0aU9pSXpOQ0lzSW5OamIzQmxJanBiSW5ZM0lpd2lkamdpTENKMk9TSXNJbll4TUNJc0luWXhNU0lzSW1Ob1lYSjBjeUlzSW1admNtMXpJaXdpWm05eWJYVnNZU0lzSW5CaGNuTmxjaUlzSW5KbGJtUmxjaUlzSW1OdmJXMWxiblJ6SWl3aWFXMXdiM0owWlhJaUxDSmlZWElpTENKMllXeHBaR0YwYVc5dWN5SXNJbk5sWVhKamFDSXNJbkJ5YVc1MElpd2ljMmhsWlhSeklpd2lZMnhwWlc1MElpd2ljMlZ5ZG1WeUlpd2ljMmhoY0dWeklpd2labTl5YldGMElsMHNJbVJsYlc4aU9uUnlkV1Y5');

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

// Create a new spreadsheet
jspreadsheet(document.getElementById('spreadsheet'), {
  worksheets: [{
    data: [
    [
        "Number",
        "Rounded to Even"
    ],
    [
        3.2,
        "=EVEN(A2)"
    ],
    [
        5.7,
        "=EVEN(A3)"
    ],
    [
        -2.1,
        "=EVEN(A4)"
    ],
    [
        8,
        "=EVEN(A5)"
    ]
]
  }]
});
</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('MDc5OWY1MDk2OGVmYzk0Yjc2NmFhMmU5NjI0OThlYWYyY2Q4MTNjZjFmNTkzYWJkNzExNjdhNjQ4YmIwOTM3NjY5YTYwZjdkMzM4ZWMyMmVlZDVjODJlNDk2NGIyZDE3Y2ZjNDEzOWNlYWU4OTk4NDg0ZTk2NDZiNDE0NTk0NDksZXlKamJHbGxiblJKWkNJNklpSXNJbTVoYldVaU9pSktjM0J5WldGa2MyaGxaWFFpTENKa1lYUmxJam94TnpVM01ETXhNRFF4TENKa2IyMWhhVzRpT2xzaWFuTndjbVZoWkhOb1pXVjBMbU52YlNJc0ltTnZaR1Z6WVc1a1ltOTRMbWx2SWl3aWFuTm9aV3hzTG01bGRDSXNJbU56WWk1aGNIQWlMQ0p6ZEdGamEySnNhWFI2TG1sdklpd2lkMlZpWTI5dWRHRnBibVZ5TG1sdklpd2lkMlZpSWl3aWJHOWpZV3hvYjNOMElsMHNJbkJzWVc0aU9pSXpOQ0lzSW5OamIzQmxJanBiSW5ZM0lpd2lkamdpTENKMk9TSXNJbll4TUNJc0luWXhNU0lzSW1Ob1lYSjBjeUlzSW1admNtMXpJaXdpWm05eWJYVnNZU0lzSW5CaGNuTmxjaUlzSW5KbGJtUmxjaUlzSW1OdmJXMWxiblJ6SWl3aWFXMXdiM0owWlhJaUxDSmlZWElpTENKMllXeHBaR0YwYVc5dWN5SXNJbk5sWVhKamFDSXNJbkJ5YVc1MElpd2ljMmhsWlhSeklpd2lZMnhwWlc1MElpd2ljMlZ5ZG1WeUlpd2ljMmhoY0dWeklpd2labTl5YldGMElsMHNJbVJsYlc4aU9uUnlkV1Y5');

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

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

    // Worksheet data
    const data = [
    [
        "Number",
        "Rounded to Even"
    ],
    [
        3.2,
        "=EVEN(A2)"
    ],
    [
        5.7,
        "=EVEN(A3)"
    ],
    [
        -2.1,
        "=EVEN(A4)"
    ],
    [
        8,
        "=EVEN(A5)"
    ]
];

    // 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('MDc5OWY1MDk2OGVmYzk0Yjc2NmFhMmU5NjI0OThlYWYyY2Q4MTNjZjFmNTkzYWJkNzExNjdhNjQ4YmIwOTM3NjY5YTYwZjdkMzM4ZWMyMmVlZDVjODJlNDk2NGIyZDE3Y2ZjNDEzOWNlYWU4OTk4NDg0ZTk2NDZiNDE0NTk0NDksZXlKamJHbGxiblJKWkNJNklpSXNJbTVoYldVaU9pSktjM0J5WldGa2MyaGxaWFFpTENKa1lYUmxJam94TnpVM01ETXhNRFF4TENKa2IyMWhhVzRpT2xzaWFuTndjbVZoWkhOb1pXVjBMbU52YlNJc0ltTnZaR1Z6WVc1a1ltOTRMbWx2SWl3aWFuTm9aV3hzTG01bGRDSXNJbU56WWk1aGNIQWlMQ0p6ZEdGamEySnNhWFI2TG1sdklpd2lkMlZpWTI5dWRHRnBibVZ5TG1sdklpd2lkMlZpSWl3aWJHOWpZV3hvYjNOMElsMHNJbkJzWVc0aU9pSXpOQ0lzSW5OamIzQmxJanBiSW5ZM0lpd2lkamdpTENKMk9TSXNJbll4TUNJc0luWXhNU0lzSW1Ob1lYSjBjeUlzSW1admNtMXpJaXdpWm05eWJYVnNZU0lzSW5CaGNuTmxjaUlzSW5KbGJtUmxjaUlzSW1OdmJXMWxiblJ6SWl3aWFXMXdiM0owWlhJaUxDSmlZWElpTENKMllXeHBaR0YwYVc5dWN5SXNJbk5sWVhKamFDSXNJbkJ5YVc1MElpd2ljMmhsWlhSeklpd2lZMnhwWlc1MElpd2ljMlZ5ZG1WeUlpd2ljMmhoY0dWeklpd2labTl5YldGMElsMHNJbVJsYlc4aU9uUnlkV1Y5');

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

export default {
    components: {
        Spreadsheet,
        Worksheet,
    },
    data() {
        // Worksheet data
        const data = [
    [
        "Number",
        "Rounded to Even"
    ],
    [
        3.2,
        "=EVEN(A2)"
    ],
    [
        5.7,
        "=EVEN(A3)"
    ],
    [
        -2.1,
        "=EVEN(A4)"
    ],
    [
        8,
        "=EVEN(A5)"
    ]
]

        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('MDc5OWY1MDk2OGVmYzk0Yjc2NmFhMmU5NjI0OThlYWYyY2Q4MTNjZjFmNTkzYWJkNzExNjdhNjQ4YmIwOTM3NjY5YTYwZjdkMzM4ZWMyMmVlZDVjODJlNDk2NGIyZDE3Y2ZjNDEzOWNlYWU4OTk4NDg0ZTk2NDZiNDE0NTk0NDksZXlKamJHbGxiblJKWkNJNklpSXNJbTVoYldVaU9pSktjM0J5WldGa2MyaGxaWFFpTENKa1lYUmxJam94TnpVM01ETXhNRFF4TENKa2IyMWhhVzRpT2xzaWFuTndjbVZoWkhOb1pXVjBMbU52YlNJc0ltTnZaR1Z6WVc1a1ltOTRMbWx2SWl3aWFuTm9aV3hzTG01bGRDSXNJbU56WWk1aGNIQWlMQ0p6ZEdGamEySnNhWFI2TG1sdklpd2lkMlZpWTI5dWRHRnBibVZ5TG1sdklpd2lkMlZpSWl3aWJHOWpZV3hvYjNOMElsMHNJbkJzWVc0aU9pSXpOQ0lzSW5OamIzQmxJanBiSW5ZM0lpd2lkamdpTENKMk9TSXNJbll4TUNJc0luWXhNU0lzSW1Ob1lYSjBjeUlzSW1admNtMXpJaXdpWm05eWJYVnNZU0lzSW5CaGNuTmxjaUlzSW5KbGJtUmxjaUlzSW1OdmJXMWxiblJ6SWl3aWFXMXdiM0owWlhJaUxDSmlZWElpTENKMllXeHBaR0YwYVc5dWN5SXNJbk5sWVhKamFDSXNJbkJ5YVc1MElpd2ljMmhsWlhSeklpd2lZMnhwWlc1MElpd2ljMlZ5ZG1WeUlpd2ljMmhoY0dWeklpd2labTl5YldGMElsMHNJbVJsYlc4aU9uUnlkV1Y5');

// 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: [
    [
        "Number",
        "Rounded to Even"
    ],
    [
        3.2,
        "=EVEN(A2)"
    ],
    [
        5.7,
        "=EVEN(A3)"
    ],
    [
        -2.1,
        "=EVEN(A4)"
    ],
    [
        8,
        "=EVEN(A5)"
    ]
]
            }]
        });
    }
}

Edit this page on GitHub