ISODD function

PRO BASIC

The ISODD function in Jspreadsheet Formulas Pro is a handy tool that helps you determine if a number is odd. When you input a number into this function, it will evaluate it and return TRUE if the number is odd. However, if the number is even, the function will return FALSE. This can be particularly useful for sorting or filtering data based on whether values are odd or even.

Documentation

Checks if a given number is odd and returns TRUE if the number is odd, and FALSE otherwise.

Syntax

ISODD(x)

Parameter	Description
`x`	The number that you want to test.

Behavior

The ISODD function in a spreadsheet checks whether a given number is odd or not. It returns TRUE if the number is odd and FALSE if it is even.

If the cell is empty, ISODD will return #VALUE! error.
If the cell contains text, ISODD will return #VALUE! error.
If the cell contains a boolean (TRUE or FALSE), ISODD will treat TRUE as 1 and FALSE as 0, thus returning TRUE for TRUE and FALSE for FALSE.
If the cell contains a non-integer numerical value, ISODD will truncate the decimal portion and consider only the integer portion.
If the cell contains an error, ISODD will return that error.

Common Errors

Error	Description
#VALUE!	This error is displayed if the input cell is empty or contains text.
#NUM!	Returned if the numeric value is invalid or outside the supported range.
#REF!	This error is displayed if the cell reference is not valid.

Best practices

Always ensure that the cell you are referencing with the ISODD function contains a numeric value to avoid #VALUE! or #NUM! errors.

Handle possible errors by using error checking functions like IFERROR in conjunction with ISODD.

Keep in mind that ISODD function will only consider the integer portion of a number. So, ISODD(2.7) will return FALSE as it considers only '2'.

Be careful with boolean values. ISODD treats TRUE as 1 and FALSE as 0 which might give you unintended results if not considered.

Usage

A few examples using the ISODD function.

ISODD(3) returns TRUE because 3 is an odd number  
ISODD(-5) returns TRUE because -5 is an odd number  
ISODD(B3) returns TRUE if cell B3 contains an odd number.

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

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

// Create a new spreadsheet
jspreadsheet(document.getElementById('spreadsheet'), {
  worksheets: [{
    data: [
    [
        "Number",
        "Is Odd?"
    ],
    [
        7,
        "=ISODD(A2)"
    ],
    [
        -3,
        "=ISODD(A3)"
    ],
    [
        8,
        "=ISODD(A4)"
    ],
    [
        15,
        "=ISODD(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('YmNhNmYwNTAxNmZmMzM4OWU0YmMwN2ZmZTQ5YjkxZjU2YjQwY2YxYmI4MWI4YTRjY2UzNmNlNjUwNjkzMjVhOGM0NzU2ZDY0YTMxNjFmMGRkZTU5Zjk2ZWQ4NTEwNTllMDUyMjhmMzUzZDZiM2QzZjMyYzRhZDdlNTk2MTdiY2IsZXlKamJHbGxiblJKWkNJNklpSXNJbTVoYldVaU9pSktjM0J5WldGa2MyaGxaWFFpTENKa1lYUmxJam94TnpVNE56ZzFPVFF6TENKa2IyMWhhVzRpT2xzaWFuTndjbVZoWkhOb1pXVjBMbU52YlNJc0ltTnZaR1Z6WVc1a1ltOTRMbWx2SWl3aWFuTm9aV3hzTG01bGRDSXNJbU56WWk1aGNIQWlMQ0p6ZEdGamEySnNhWFI2TG1sdklpd2lkMlZpWTI5dWRHRnBibVZ5TG1sdklpd2lkMlZpSWl3aWJHOWpZV3hvYjNOMElsMHNJbkJzWVc0aU9pSXpOQ0lzSW5OamIzQmxJanBiSW5ZM0lpd2lkamdpTENKMk9TSXNJbll4TUNJc0luWXhNU0lzSW1Ob1lYSjBjeUlzSW1admNtMXpJaXdpWm05eWJYVnNZU0lzSW5CaGNuTmxjaUlzSW5KbGJtUmxjaUlzSW1OdmJXMWxiblJ6SWl3aWFXMXdiM0owWlhJaUxDSmlZWElpTENKMllXeHBaR0YwYVc5dWN5SXNJbk5sWVhKamFDSXNJbkJ5YVc1MElpd2ljMmhsWlhSeklpd2lZMnhwWlc1MElpd2ljMlZ5ZG1WeUlpd2ljMmhoY0dWeklpd2labTl5YldGMElsMHNJbVJsYlc4aU9uUnlkV1Y5');

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

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

    // Worksheet data
    const data = [
    [
        "Number",
        "Is Odd?"
    ],
    [
        7,
        "=ISODD(A2)"
    ],
    [
        -3,
        "=ISODD(A3)"
    ],
    [
        8,
        "=ISODD(A4)"
    ],
    [
        15,
        "=ISODD(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('YmNhNmYwNTAxNmZmMzM4OWU0YmMwN2ZmZTQ5YjkxZjU2YjQwY2YxYmI4MWI4YTRjY2UzNmNlNjUwNjkzMjVhOGM0NzU2ZDY0YTMxNjFmMGRkZTU5Zjk2ZWQ4NTEwNTllMDUyMjhmMzUzZDZiM2QzZjMyYzRhZDdlNTk2MTdiY2IsZXlKamJHbGxiblJKWkNJNklpSXNJbTVoYldVaU9pSktjM0J5WldGa2MyaGxaWFFpTENKa1lYUmxJam94TnpVNE56ZzFPVFF6TENKa2IyMWhhVzRpT2xzaWFuTndjbVZoWkhOb1pXVjBMbU52YlNJc0ltTnZaR1Z6WVc1a1ltOTRMbWx2SWl3aWFuTm9aV3hzTG01bGRDSXNJbU56WWk1aGNIQWlMQ0p6ZEdGamEySnNhWFI2TG1sdklpd2lkMlZpWTI5dWRHRnBibVZ5TG1sdklpd2lkMlZpSWl3aWJHOWpZV3hvYjNOMElsMHNJbkJzWVc0aU9pSXpOQ0lzSW5OamIzQmxJanBiSW5ZM0lpd2lkamdpTENKMk9TSXNJbll4TUNJc0luWXhNU0lzSW1Ob1lYSjBjeUlzSW1admNtMXpJaXdpWm05eWJYVnNZU0lzSW5CaGNuTmxjaUlzSW5KbGJtUmxjaUlzSW1OdmJXMWxiblJ6SWl3aWFXMXdiM0owWlhJaUxDSmlZWElpTENKMllXeHBaR0YwYVc5dWN5SXNJbk5sWVhKamFDSXNJbkJ5YVc1MElpd2ljMmhsWlhSeklpd2lZMnhwWlc1MElpd2ljMlZ5ZG1WeUlpd2ljMmhoY0dWeklpd2labTl5YldGMElsMHNJbVJsYlc4aU9uUnlkV1Y5');

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

export default {
    components: {
        Spreadsheet,
        Worksheet,
    },
    data() {
        // Worksheet data
        const data = [
    [
        "Number",
        "Is Odd?"
    ],
    [
        7,
        "=ISODD(A2)"
    ],
    [
        -3,
        "=ISODD(A3)"
    ],
    [
        8,
        "=ISODD(A4)"
    ],
    [
        15,
        "=ISODD(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('YmNhNmYwNTAxNmZmMzM4OWU0YmMwN2ZmZTQ5YjkxZjU2YjQwY2YxYmI4MWI4YTRjY2UzNmNlNjUwNjkzMjVhOGM0NzU2ZDY0YTMxNjFmMGRkZTU5Zjk2ZWQ4NTEwNTllMDUyMjhmMzUzZDZiM2QzZjMyYzRhZDdlNTk2MTdiY2IsZXlKamJHbGxiblJKWkNJNklpSXNJbTVoYldVaU9pSktjM0J5WldGa2MyaGxaWFFpTENKa1lYUmxJam94TnpVNE56ZzFPVFF6TENKa2IyMWhhVzRpT2xzaWFuTndjbVZoWkhOb1pXVjBMbU52YlNJc0ltTnZaR1Z6WVc1a1ltOTRMbWx2SWl3aWFuTm9aV3hzTG01bGRDSXNJbU56WWk1aGNIQWlMQ0p6ZEdGamEySnNhWFI2TG1sdklpd2lkMlZpWTI5dWRHRnBibVZ5TG1sdklpd2lkMlZpSWl3aWJHOWpZV3hvYjNOMElsMHNJbkJzWVc0aU9pSXpOQ0lzSW5OamIzQmxJanBiSW5ZM0lpd2lkamdpTENKMk9TSXNJbll4TUNJc0luWXhNU0lzSW1Ob1lYSjBjeUlzSW1admNtMXpJaXdpWm05eWJYVnNZU0lzSW5CaGNuTmxjaUlzSW5KbGJtUmxjaUlzSW1OdmJXMWxiblJ6SWl3aWFXMXdiM0owWlhJaUxDSmlZWElpTENKMllXeHBaR0YwYVc5dWN5SXNJbk5sWVhKamFDSXNJbkJ5YVc1MElpd2ljMmhsWlhSeklpd2lZMnhwWlc1MElpd2ljMlZ5ZG1WeUlpd2ljMmhoY0dWeklpd2labTl5YldGMElsMHNJbVJsYlc4aU9uUnlkV1Y5');

// 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",
        "Is Odd?"
    ],
    [
        7,
        "=ISODD(A2)"
    ],
    [
        -3,
        "=ISODD(A3)"
    ],
    [
        8,
        "=ISODD(A4)"
    ],
    [
        15,
        "=ISODD(A5)"
    ]
]
            }]
        });
    }
}

Edit this page on GitHub