RAND function

PRO BASIC

The RAND function in Jspreadsheet Formulas Pro is used to produce a random decimal number between 0 and 1. This number updates every time the worksheet recalculates, meaning it changes every time you make a change to your data. It's a simple and effective way to create random values on your spreadsheet.

Documentation

Generates a random decimal number between 0 and 1. The value of the number changes each time the worksheet is calculated or when the function is recalculated by pressing F9.

Syntax

RAND()

Parameter	Description

Behavior

The RAND function returns a random number greater than or equal to 0 and less than 1, distributed uniformly. It does not require any arguments. Each time a worksheet is recalculated by entering a formula, or by manually recalculating (pressing F9), a new random number is produced.

Empty cells: As RAND function does not require any arguments, empty cells do not affect its behavior.
Text: RAND function ignores any text or string as it does not require any arguments.
Booleans: Similarly, RAND function does not interact with Boolean values as it does not require any arguments.
Errors: RAND function does not produce any errors, unless the spreadsheet software encounters a calculation error.

Common Errors

Error	Description
Calculation Error	This error can occur if the spreadsheet software encounters a calculation error. However, this is extremely rare with `RAND` function.

Best practices

Since RAND function generates a new random number every time the worksheet is recalculated, you may want to keep the generated random numbers static. To do this, copy the cells with RAND function and paste them as values.

If you need to generate a random number within a specific range, you can use the formula RAND()*(b-a) + a, where a is the start of your range and b is the end of your range.

Be aware that RAND function produces a uniformly distributed random number. If you need a different distribution, you may need to use a different function or formula.

RAND function can be combined with other functions to produce more complex random behaviors. For example, RANDBETWEEN can be used to generate random integers within a specific range.

Usage

A few examples using the RAND function.

RAND()  
→ Returns a random decimal number between 0 and 1

IF(RAND()>0.5, "Heads", "Tails")  
→ Simulates a coin flip with 50% chance of Heads or Tails.

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

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

// Create a new spreadsheet
jspreadsheet(document.getElementById('spreadsheet'), {
  worksheets: [{
    data: [
    [
        "Random Number",
        "Coin Flip",
        "Dice Roll"
    ],
    [
        "=RAND()",
        "=IF(RAND()>0.5,\"Heads\",\"Tails\")",
        "=INT(RAND()*6)+1"
    ],
    [
        "=RAND()",
        "=IF(RAND()>0.5,\"Heads\",\"Tails\")",
        "=INT(RAND()*6)+1"
    ],
    [
        "=RAND()",
        "=IF(RAND()>0.5,\"Heads\",\"Tails\")",
        "=INT(RAND()*6)+1"
    ],
    [
        "=RAND()",
        "=IF(RAND()>0.5,\"Heads\",\"Tails\")",
        "=INT(RAND()*6)+1"
    ]
]
  }]
});
</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('ZGVkOGMzMzExOTJjYTQ1OTdmNTFiNDNjM2UxYjgwMTQwYTk0ZjMyNzE2Y2MxN2EyM2YxMTQwODc4MzJjNzVjOGU3ZDg2MjFmOTU5MjM1N2MxZjFiNDk3ZDMyMWYxMjEwMGE0OGM0MTIyMjhiODk5OTVlZjhlNjBkYjk0MDc4NGEsZXlKamJHbGxiblJKWkNJNklpSXNJbTVoYldVaU9pSktjM0J5WldGa2MyaGxaWFFpTENKa1lYUmxJam94TnpVNE56YzBNRE14TENKa2IyMWhhVzRpT2xzaWFuTndjbVZoWkhOb1pXVjBMbU52YlNJc0ltTnZaR1Z6WVc1a1ltOTRMbWx2SWl3aWFuTm9aV3hzTG01bGRDSXNJbU56WWk1aGNIQWlMQ0p6ZEdGamEySnNhWFI2TG1sdklpd2lkMlZpWTI5dWRHRnBibVZ5TG1sdklpd2lkMlZpSWl3aWJHOWpZV3hvYjNOMElsMHNJbkJzWVc0aU9pSXpOQ0lzSW5OamIzQmxJanBiSW5ZM0lpd2lkamdpTENKMk9TSXNJbll4TUNJc0luWXhNU0lzSW1Ob1lYSjBjeUlzSW1admNtMXpJaXdpWm05eWJYVnNZU0lzSW5CaGNuTmxjaUlzSW5KbGJtUmxjaUlzSW1OdmJXMWxiblJ6SWl3aWFXMXdiM0owWlhJaUxDSmlZWElpTENKMllXeHBaR0YwYVc5dWN5SXNJbk5sWVhKamFDSXNJbkJ5YVc1MElpd2ljMmhsWlhSeklpd2lZMnhwWlc1MElpd2ljMlZ5ZG1WeUlpd2ljMmhoY0dWeklpd2labTl5YldGMElsMHNJbVJsYlc4aU9uUnlkV1Y5');

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

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

    // Worksheet data
    const data = [
    [
        "Random Number",
        "Coin Flip",
        "Dice Roll"
    ],
    [
        "=RAND()",
        "=IF(RAND()>0.5,\"Heads\",\"Tails\")",
        "=INT(RAND()*6)+1"
    ],
    [
        "=RAND()",
        "=IF(RAND()>0.5,\"Heads\",\"Tails\")",
        "=INT(RAND()*6)+1"
    ],
    [
        "=RAND()",
        "=IF(RAND()>0.5,\"Heads\",\"Tails\")",
        "=INT(RAND()*6)+1"
    ],
    [
        "=RAND()",
        "=IF(RAND()>0.5,\"Heads\",\"Tails\")",
        "=INT(RAND()*6)+1"
    ]
];

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

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

export default {
    components: {
        Spreadsheet,
        Worksheet,
    },
    data() {
        // Worksheet data
        const data = [
    [
        "Random Number",
        "Coin Flip",
        "Dice Roll"
    ],
    [
        "=RAND()",
        "=IF(RAND()>0.5,\"Heads\",\"Tails\")",
        "=INT(RAND()*6)+1"
    ],
    [
        "=RAND()",
        "=IF(RAND()>0.5,\"Heads\",\"Tails\")",
        "=INT(RAND()*6)+1"
    ],
    [
        "=RAND()",
        "=IF(RAND()>0.5,\"Heads\",\"Tails\")",
        "=INT(RAND()*6)+1"
    ],
    [
        "=RAND()",
        "=IF(RAND()>0.5,\"Heads\",\"Tails\")",
        "=INT(RAND()*6)+1"
    ]
]

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

// 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: [
    [
        "Random Number",
        "Coin Flip",
        "Dice Roll"
    ],
    [
        "=RAND()",
        "=IF(RAND()>0.5,\"Heads\",\"Tails\")",
        "=INT(RAND()*6)+1"
    ],
    [
        "=RAND()",
        "=IF(RAND()>0.5,\"Heads\",\"Tails\")",
        "=INT(RAND()*6)+1"
    ],
    [
        "=RAND()",
        "=IF(RAND()>0.5,\"Heads\",\"Tails\")",
        "=INT(RAND()*6)+1"
    ],
    [
        "=RAND()",
        "=IF(RAND()>0.5,\"Heads\",\"Tails\")",
        "=INT(RAND()*6)+1"
    ]
]
            }]
        });
    }
}

Edit this page on GitHub