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
RandBetween returns an integer.
Try =RANDBETWEEN(0, 16)/4
_
...How to Cross-post politely...
..Wrap code by selecting the code and clicking the # or read this. Thank you.
randbetween will only return an integer (http://spreadsheets.about.com/b/2009...n-function.htm), so try this work-around
=RANDBETWEEN(100,400)/100
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Thank you both for your help. It is appreciated
you'r welcome. If this answered your question, please take a moment to mark the thread as "solved" - it helps keep things neet and tidy lol, and consider adding the reputation to those that helped (see points 2 & 3 below)
Thanks for the star
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks