RANDBETWEEN - Returning a Random Integer between Two Values

  • Last update:  2023-07-14
  • Overview

    Grammar

    RANDBETWEEN(value1, value2)

    Returns a random integer between value1 and value2.

    When the two values have the same integer, this integer will be returned.

    Parameter

    value1,value2

    Any number.

    Notes

    • The function supports two numerical parameters.

    Example

    Formula

    Result

    RANDBETWEEN(12.333, 13.233)

    Returns only 13.

    RANDBETWEEN(11.2, 13.3)

    Returns 12 or 13.

    RANDBETWEEN(12.333, 12.233)

    Returns only 12.


    Attachment List


    Theme: Advanced Data Analyis
    前の記事
    次の記事
    • いいね
    • 良くない
    • 閲覧しただけ

    フィードバック

    鼠标选中内容,快速反馈问题

    鼠标选中存在疑惑的内容,即可快速反馈问题,我们将会跟进处理。

    不再提示

    7s后关闭

    反馈已提交

    网络繁忙