Excel RandBetween Formula

Randbetween formula gives the result of the random values given by the range, we will get dynamic values from this formula very useful formula if you want to display random values within the particular range. 1) If you want to display random values from 1 to 10 then how to do? Ans: =RANDBETWEEN(1,10) Explanation In Excel, each formula must with "=" sign, you can also use "+" and "@" sign at the start of the formula. Randbetween is the name of the function which gives us the random values Randbetween function has two parameters i) Bottom ii) Top In our scenario we want values from 1 to 10 then the bottom parameter should be 1  and the top parameter should be 10. 2) If you want to display random dates from 1st January 2018 to 30 January 2018 Ans: =RANDBETWEEN("1-1-2018","1-30-2018") Explanation : To display dates random value you have to use Randbetween formula with parameters bottom and top. The first par