View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Ron Rosenfeld Ron Rosenfeld is offline
external usenet poster
 
Posts: 5,651
Default What function will give me a random full number from 1 to 6

On Sun, 8 May 2005 06:06:04 -0700, Audrey
wrote:

and just for another method, if you have the Analysis ToolPak installed:

=RANDBETWEEN(1,6)

If this function is not available, and returns the #NAME? error, install and
load the Analysis ToolPak add-in.

On the Tools menu, click Add-Ins.
In the Add-Ins available list, select the Analysis ToolPak box, and then click
OK.
If necessary, follow the instructions in the setup program.

--ron