Excel+The+creation+of+Random+Numbers+in

Excel The creation of Random Numbers in

The function RAND

Is malfunctioning in Excel it is supposed to create random numbers between 0 ( Zero) and 1

However it sometimes creates a negative value which is of no use to anyone.

Following a lot of hassle to Microsoft ,they have finally admitted the problem and produced a fix which is available from :‐

[|www. support.microsoft.com/default.aspx?kbid=834520]

Hope this helps the frustrated mathematicians amongst you

And to those who do not know to obtain a value between 0‐9

You multiply the Random number in another formulae by 10 e.g. 0.8976*10

This gives you a value of 8 plus and you can then decide to what decimal point etc.

The explanations and developments that could follow this are enormous, but just think about it