Results 1 to 2 of 2
  1. #1
    2 Star Lounger
    Join Date
    Jan 2002
    Location
    Cape Cod
    Posts
    117
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Negative Numbers (Excel 2000)

    I know that =rand() will generate a random number between 0 and 1. How do I generate a negative number?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Negative Numbers (Excel 2000)

    For example:

    =-RAND()

    for a random number between 0 and -1 , or

    =-5*RAND()

    for a random number between 0 and -5.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •