If you need to generate a random number between a defined minimal and maximal value with a specified number of decimal places, you can use this UDF.
If you are interested in downloading a 15 KB Excel 2010 sample file go to my Download page, please.
I am a supporter of St. Joseph's hospice. If you find this site useful or if it helped you, consider a small donation to St. Joseph's, please.
