View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
denise1082 denise1082 is offline
external usenet poster
 
Posts: 3
Default HELP with the RAND() Function!!!!!!

Thanks for responding Harald!!!

From reading the assignment question, I get that any position can have any
digit. It didn't say anything about odd/even numbers or certain numbers
totalling up to something. Im sure it's a simple problem but I have no clue!!
!! I don't even know how the social security format would be created using
the RAND function. Thanks again for your help!

Harald Staff wrote:
Hi

Start with finding out how this number is built. Can any position have any
digit, or are there some rules of odd/even numbers, certain numbers
totalling up to something, control digits, ... ?

HTH. Best wishes Harald

For my assignment, I am supposed to create a worksheet that will generate a
random social security number (using the correct social security form of 000-
00-0000) There are supposed to be a billion social security possibilities
and each should be equally likely to be selected in the worksheet. I have no
idea where to start with this assignment!!! Any help whatsoever would be
greatly appreciated!!!! Thanks