•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
How do i control the randomization of the values? (For mapmaking)
So i want to create a map in Excel, like an actual fantasy map. The values in the cell are the elevation. Then based on the elevation values, the color changes with conditional formatting.
I know I could manually input the values yes but I want to automatically generate them while still keeping a semblance of landmasses.
Right now I'm using the RAND() to randomize the values but as you can see the values are all over the place (see image below). How do I control the values randomization so that <0.1 (water) will group together and >0.1 (land) will not be isolated?
[link] [comments]
Want to read more?
Check out the full article on the original site