+ Reply to Thread
Results 1 to 5 of 5

Using RANDBETWEEN to calculcate percentage of a score

  1. #1
    Registered User
    Join Date
    11-06-2006
    Posts
    5

    Using RANDBETWEEN to calculcate percentage of a score

    I am using Excel for an assignment in my university business class. I have never used Excel before, so I really have no idea how to put in the arguments correctly for which function.

    Right now I need to use the RANDBETWEEN function to calculate a percentage between 25% and 75% of a score of 75.

    I know how to use it in the sense of =RANDBETWEEN(1,50), for example, but I don't know how to incorperate percents or how to make it a percentage of that specific number.

    Please help?

  2. #2
    Forum Contributor
    Join Date
    06-10-2004
    Location
    India
    Posts
    1,066
    =RANDBETWEEN(25,75)/100

    and format as percents
    Mangesh

  3. #3
    Registered User
    Join Date
    11-06-2006
    Posts
    5
    It needs to be 25%-75% of a score of 75, (or the score in the certain cell).

    Isn't there a way to use it like

    EXAMPLE:

    =RANDBETWEEN(25%,100%)/C2

    If I just divide by a hundred, I might get a percentage out of the range of 25-75 percent of the total.

  4. #4
    Forum Contributor
    Join Date
    06-10-2004
    Location
    India
    Posts
    1,066
    =RANDBETWEEN(25,75)/100*75
    or
    =RANDBETWEEN(25,75)/100*A1
    if A1 contains your score

  5. #5
    Registered User
    Join Date
    11-06-2006
    Posts
    5
    Thanks, the formula works!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1