+ Reply to Thread
Results 1 to 3 of 3

How to fix generated random numbers in this formula?

  1. #1
    Registered User
    Join Date
    02-24-2009
    Location
    Tehran
    MS-Off Ver
    Excel 2010
    Posts
    45

    Question How to fix generated random numbers in this formula?

    I need to fix generated random numbers in below formula after insertion into cell :

    Please Login or Register  to view this content.
    Now with every generated data through formula, random values would change; so final outputs will be not based on latest generated numbers.
    Last edited by omid020; 10-20-2013 at 03:20 AM. Reason: Solved

  2. #2
    Forum Guru HaHoBe's Avatar
    Join Date
    02-19-2005
    Location
    Hamburg, Germany
    MS-Off Ver
    work: 2016 on Win10 (notebook), private: 2019 on Win10 (desktop), 2019 on Win11 (notebook)
    Posts
    8,197

    Re: How to fix generated random numbers in this formula?

    Hi, omid020,

    maybe instead of
    Please Login or Register  to view this content.
    use
    Please Login or Register  to view this content.
    which will put the result and not the formula to the cell.

    Ciao,
    Holger
    Use Code-Tags for showing your code: [code] Your Code here [/code]
    Please mark your question Solved if there has been offered a solution that works fine for you

  3. #3
    Registered User
    Join Date
    02-24-2009
    Location
    Tehran
    MS-Off Ver
    Excel 2010
    Posts
    45

    Re: How to fix generated random numbers in this formula?

    Great solution HaHoBe!
    Thank you!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Storing the output generated from random numbers in different cells
    By rafat125 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 04-12-2013, 02:07 AM
  2. random answers generated from a list
    By juicy fruit in forum Excel General
    Replies: 9
    Last Post: 04-11-2010, 07:22 AM
  3. I want random numbers generated without repeating
    By Johncobb45 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-08-2006, 08:53 PM
  4. Non-random numbers generated by excel's data analysis random gener
    By Allie in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 09-17-2005, 02:05 AM
  5. [SOLVED] Re: Non-random numbers generated by excel's data analysis random gener
    By Harlan Grove in forum Excel General
    Replies: 2
    Last Post: 09-13-2005, 12:05 PM

Tags for this Thread

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