MSEXCELTRAINING.CO.UK
Menu
 

Advice
Need help finding the right training? Contact our consultants!
Ring 020 3014 3820

Quote Request
Tell us what your training needs are and our dedicated experts will try and provide you with relevant courses and training providers. Cost & Obligation Free.

Click here


Microsoft Excel training

Generate random numbers in Excel

In Excel, you can use the Random function to generate random numbers. Together with the Integer function, you can generate a random integer between 0 and given number.

Follow these steps to generate a random integer in Excel

  1. To generate an integer between 0 and 100, enter the following formula into your Excel cell  =INT(RAND()*100)
  2. Save the cell/confirm by hitting the Enter key

Nice, simple and easy.




   
excel, generate, random, integer
Copyright © 2010 findcourses.co.uk. All rights reserved Sitemap | Contact us