*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.

## 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

### 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

YOU MAY LIKE

- HOW TO TROUBLESHOOT A FORMULA IN EXCEL?
- USE OF FONTS, FONT SIZE, INDENTATION, TEXT TO THE RIGHT, TEXT TO THE LEFT, TEXT IN THE MIDDLE ETC.
- how to insert table in excel?
- FOR MORE ARTICLES, CLICK EXCEL OR TYPE IN SEARCH BELOW.