LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Akion
 
Posts: n/a
Default Random funtion


HI i've got a small peice of work which requires a spread sheet to show
a random value of 1, 3 or 0 but not 2 the formular i have so far is
=ROUND(RAND()*3,0) cana ny one direct me to my mistake as i am rather
amatuerish at excels functions.


--
Akion
------------------------------------------------------------------------
Akion's Profile: http://www.excelforum.com/member.php...o&userid=35713
View this thread: http://www.excelforum.com/showthread...hreadid=554965

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Seed numbers for random number generation, uniform distribution darebo Excel Discussion (Misc queries) 3 April 21st 23 09:02 PM
Random Number response Union70 Excel Worksheet Functions 1 April 27th 06 06:27 PM
Random Sampling Andrea Excel Discussion (Misc queries) 2 November 11th 05 09:52 AM
Generate random numberes using reference to the other cell. ramana Excel Worksheet Functions 7 October 31st 05 07:09 AM
VBA "Rnd" Function: Truly Random? TheRobsterUK Excel Discussion (Misc queries) 2 September 27th 05 04:50 AM


All times are GMT +1. The time now is 10:04 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"