Results 1 to 6 of 6

Grade Point Average

Threaded View

  1. #1
    Registered User
    Join Date
    09-26-2012
    Location
    New York, NY
    MS-Off Ver
    Excel 2010
    Posts
    21

    Grade Point Average

    Hello Mates,

    Needing to calculate random GPA's. 0.00-4.00. My formula I have written is =RANDBETWEEN(0.00-4.00) however, it is only returning whole integers. I need random averages to be D.DD i.e. 3.25, 2.50, etc..... Where am I going wrong? I try to format the cells of the whole numbers to fractions - but no luck. Any help is appreciated.


    Solved
    Last edited by gregfetzer; 09-27-2012 at 04:39 PM. Reason: Solved

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