Random number in Excel can we also set some range in random number?

Hi Guest

MobileUser

HomePage

Jobs

WalkIn

Articles

:) Latest Topic

AJAX

VB.NET

SQL Query

UDDI

CLASS

JavaScript Questions

SharePoint Interview

SilverLight

WCF

general knowledge

ASP.NET

:) Hot Jobs

:) Latest Articles

Random number in Excel can we also set some range in random number?
Question Posted on 24 Aug 2021

Home >> Microsoft Products >> Microsoft Excel >> Random number in Excel can we also set some range in random number?

Random number in Excel can we also set some range in random number?
There are some inbuilt function available in excel mainly a method is "rand()" and its default range is 0 to 1. And you will get below number after selecting rand() method as given below.

Rand() excel

And if we want to display random number within specific range as given below.

RANDBETWEEN(0,100)

	0
	0