Thread: [Solved] RANDBETWEEN question
View Single Post
 
Old 01-25-2019, 06:31 AM
derohanes derohanes is offline Windows 10 Office 2013
Advanced Beginner
 
Join Date: Oct 2008
Posts: 67
derohanes is on a distinguished road
Default RANDBETWEEN question

I am trying to generate a column of random numbers between the values in the first and second column, using RANDBETWEEN(F3,G3) in column H (the third column). The result is not what I expect, all 1s. How can I get a random number between the first two numbers?
[IMG]C:\Users\edd\Desktop\Untitled.jpg[/IMG]
Attached Images
File Type: jpg Untitled.jpg (34.3 KB, 20 views)
Reply With Quote