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

CONTENTS

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.
Helpful links for the prerequisites mentioned above

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.
 

 

EXCEL RANDBETWEEN EXAMPLE
EXCEL:RANDBETWEEN FUNCTION ANIMATED EXAMPLE

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.

OTHER WAYS TO REACH THIS ARTICLE

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

LEARN

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

Pin It on Pinterest

Share This

KINDLY SPEND FEW SECONDS HERE....

%d bloggers like this: