Results 1 to 4 of 4

RAND function with upper and lower limits

Threaded View

Grimace RAND function with upper and... 04-12-2011, 07:03 PM
daddylonglegs Re: RAND function with upper... 04-12-2011, 07:11 PM
Grimace Re: RAND function with upper... 04-12-2011, 07:26 PM
Grimace Re: RAND function with upper... 04-12-2011, 07:29 PM
  1. #1
    Forum Contributor Grimace's Avatar
    Join Date
    05-04-2009
    Location
    Gold Coast, Australia
    MS-Off Ver
    Excel 2013 and Office 365 Plus
    Posts
    380

    RAND function with upper and lower limits

    Good morning

    I am using 2003 and do not have the RANDBETWEEN funtion available.

    Does anyone have a formula that will generate the random numbers but between an upper and lower limit? eg In some cases I want to limit it to between 80% and 100%.

    Thanks in advance

    Darren
    Last edited by Grimace; 04-12-2011 at 08:29 PM.

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