
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.
RANDBETWEEN FUNCTION RETURNS A RANDOM NUMBER IN A SPECIFIED RANGE.
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 less than or equal to 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.
The function is helpful when our application or report needs to generate a random number.
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 FUNCTION
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.