abc MICROSOFT EXCEL 2010 - Functions
Random value from 0 to 10 /FUNCTION RAND/

Function RAND (RANDOMIZE) lists a random value in the interval of 0-1. A coefficient can be used to change the range. Function RAND is a MATH & TRIG Function..


Picture 1. Random value inbetween 0-10 /FUNCTION RAND/

Random value od 0-10 /FUNCTION RAND/, steps:

  1. Select the cell for the random value listing.
  2. Click on the button Insert Function /INSERT FUNCTION/ .
  3. MATH & TRIG Option in the dropdown menu.
  4. Select RAND function.
  5. OK button
  6. Define the area (group of cells).
  7. OK button
  8. Add coefficent 10* for calculating RAND,
  9. Using the Fill Marker /FILL MARKER/ change the other cells as well.
  10. All values are in the range from 0 to 10.
  11. The end (Kraj).

Functions    Index