« What's New in EXCEL 2013? | Formulas Cheat Voice (Revealed) » |
Hi there,
How are you doing today. Hope all is well. Today, I have learnt how to get decimal values using RANDBETWEEN. So, anxiety to share with you before I forget.
HOW RANDBETWEEN WORKS?
This function can be used when we require random numbers between the two numbers. This function has two arguments that is bottom and top. In the argument bottom keep the lowest value and in arugment top place the largest value which needs to display randomly.
...
Keep pressing F9 or SHIFT + F9 to see how this function works.
For eg: =RANDBETWEEN(1,10) returns values between 1 to 10.
HOW TO GET DECIMALS FROM THIS?
To get decimals divide the above function with 10, gives decimals between 0.1 to 1.
Eg: =RANDBETWEEN(1,10)/10 returns values between 0.1 to 1
That's it Magic works.
HOMEWORK:
1. How to get decimals between 0.01 to 0.1?
2. How to get decimals between 0.005 to 0.08?
Note: Post your answers in the below comments section.
DO YOU USE RANDBETWEEN?
Have you tried this function @ your work. Did you find any challenges while working on it. Please use our comments section below to post your ideas, suggestions, feedbacks and what you expect from exceltoxl.
If you like this post, please share it on your social networking sites by clicking on the icons placed around the blog.
If you want to support me, please do REGISTER here. You will receive monthly newsletters as well as FORMULAS CHEAT SHEET.
Thanks,
You must be logged in to see the comments. Log in now!
If you have no account yet, you can register now! (It only takes a few seconds)
Recent comments