Power Query Course in Spanish
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: Random Number? Formula?

  1. #1
    Board Regular
    Join Date
    Feb 2002
    Location
    Dallas, TX
    Posts
    316
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hello All,

    I have a grid, rows are profit per unit, starting a 500 and going down to 3,175 in increments of 25. The columns are units starting at 25 and going to 250, incrementing by 5.

    I want a formula to calculate a number that is always greater than the cell to the left of it, and always greater than the cell above. Can't go over 40 though. Each column will start slightly above 0 and max at forty.

    Any ideas?

  2. #2
    MrExcel MVP Al Chara's Avatar
    Join Date
    Feb 2002
    Location
    Newark, Delaware
    Posts
    1,701
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Are the numbers you gave (ie 500 to 3175 and 25 to 250) just column and row headings? How high above 0 do you want the numbers to start at?

  3. #3
    Board Regular
    Join Date
    Feb 2002
    Location
    Dallas, TX
    Posts
    316
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Yes, the columns actually start at 1, then 5 10 15 20 etc...to 250. The Rows start at 500 and go to 3175.

    I want to start around .5 and max at 40. I've been playing with RAND()*(C6-D5)+D5, but that's not working. Any help would be greatly appreciated.

    Steve

  4. #4
    MrExcel MVP Al Chara's Avatar
    Join Date
    Feb 2002
    Location
    Newark, Delaware
    Posts
    1,701
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Don't have time to figure this out, but I will send it to the top of the list. For clarification, do you want the number to be greater than the cell above and less than the cell to the left? Your description in your post did not make sense.

    Can I ask what the significance of the row and column headings is and why you want random numbers from .5 to 40?

    [ This Message was edited by: Al Chara on 2002-03-20 15:44 ]

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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