 PROVIDING ACCURATE, RELIABLE AND STRAIGHT TO THE POINT KNOWLEDGE ABOUT DIFFERENT IT TOOLS EXPLAINED WITH PRACTICAL EXAMPLES

# EXCEL FUNCTIONS-RANDBETWEEN

## INTRODUCTION

RANDBETWEEN  FUNCTION comes under MATH AND TRIG function class in Excel.

It helps us to generate a random number between two specific ranges.

Random number is used for creating some application where we need to create a random number.

Returns an evenly distributed random real number greater than or equal to LOWER SPECIFIED NUMBER and HIGHER SPECIFIED NUMBER.

A new number will be calculated every time the formula is refreshed or workbook is loaded.

## PURPOSE OF RANDBETWEEN FUNCTION IN EXCEL

RANDBETWEEN FUNCTION returns the random real number between two specified numbers.

## PREREQUISITES TO LEARN RANDBETWEEN

THERE ARE A FEW PREREQUISITES WHICH WILL ENABLE YOU TO UNDERSTAND THIS FUNCTION IN A BETTER WAY.

•  Basic understanding of how to use a formula or function.
•  Basic understanding of rows and columns in Excel.
• Some information about the financial terms is an advantage for the use of such formulas.
•  Of course, Excel software.

## SYNTAX: RANDBETWEEN()

The Syntax for the function is

=RANDBETWEEN(LOWEST NUMBER, HIGHEST NUMBER)

LOWEST NUMBER Lowest possible number

HIGHEST NUMBER Highest possible number

## EXAMPLE:RANDBETWEEN FUNCTION IN EXCEL

### DATA SAMPLE

SUPPOSE WE NEED TO CALCULATE A RANDOM NUMBER BETWEEN A AND B
where A is lower number and B is higher number. The formula will be
=RANDBETWEEN(A,B)
Suppose we need to create numbers between 0 and 81.

### STEPS TO USE RANDBETWEEN FUNCTION

The cell E8 is used to create random numbers.

The function used is

=RANDBETWEEN(0,81)

The number generated will be between 0 and 81.

## CONFUSION CLARIFICATIONS

### DECIMAL RANDOM NUMBERS

RANDBETWEEN FUNCTION can’t be used to create a decimal number.

It’ll always return an integer. For more precise random number calculation , we need to go to the more basic RAND FUNCTION.

• ## WHAT IS EXCEL, HOW EXCEL WORKS, WRITE FORMULA IN EXCEL, EXAMPLE OF USING FORMULA IN EXCEL, ANIMATED EXAMLPE OF USING FORMULA IN EXCEL

LEARN

• EXCEL
• JAVASCRIPT
• MORE TO COME…

Encourage us by following at …

If you have any queries or suggestions or any problem which you would like us to solve for you, kindly mail at

gyankosh060309@gmail.com