Results 1 to 11 of 11

Generate random values that are a function of % calculations

Threaded View

  1. #1
    Forum Contributor
    Join Date
    08-06-2018
    Location
    Virginia
    MS-Off Ver
    2019
    Posts
    342

    Generate random values that are a function of % calculations

    Experts:

    I need some assistance with generating some *random numbers* for four (4) metrics. However, the random numbers are a functions of several % calculations.

    The four metrics are (I'm using acronyms for demo purposes only):
    "A"
    "B"
    "C"
    "D"

    Also, for each of the four metrics (A:D), I have calculations for 16 systems (1:16).

    At this moment, I recommend to open the attached XLS... I think it'll help to better follow along w/ the % calculations:

    Example Data:
    - I have the 4 metrics (A:D) in cells A3:A6
    - I have example data (25, 49, 21, 42) in cells B3:B6
    - Now, cells A11:A14 shows the calculations/functions for the four metrics.
    - For instance, the 1st metric = "A/B". Thus, once I divide 25 by 49, I get 51%... check on the % value in B11.
    - Alternatively, the 2nd metric = "C/D". Thus, once I divide 21 by 42, I get 50%... check on the % value in B12.
    - Similarly, 3rd metric = "A/D" (60%) while 4th metric = "C/A" (84%).
    - Again, the values in cells B3:B6 are sample values.

    What I need some help with:
    - Now, for cells C3:Q6, I do NOT have any sample data.
    - So, I want to populate C3:Q6 with *random* data.
    - The random data, however, must give me the % values (which I do have) listed in C11:Q14.
    - I learned it is easy to generate the 1st metric. That is, I used, e.g., =Randbetween(10,99) in cell C22:Q22.
    - Next, using simple multiplication, I chose formula "=C11*C22" to populate row 21.
    - Thus, in my temporary validation section (rows 27 through 32), row 29 shows the correct output. That is, % values in row 29 match those of row 11...
    - However, once I continue on to derive at some of the other random values, my existing percentage calculations in rows 29:32 no longer match those in rows 11:14.

    My question:
    Is there a way to use formulas to derive at the correct random values (in rows 21:24) so that all of my calculations in rows 29:32 match the required % values listed in rows 11:14?

    EEH
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. RANDOM function to generate teams with an exception
    By iiMike in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 11-19-2019, 11:08 AM
  2. Using Random function and Vlookup to generate a time
    By FerociousCamel in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-06-2018, 08:15 PM
  3. [SOLVED] Random Generate values of a column
    By jrable in forum Excel General
    Replies: 12
    Last Post: 11-14-2014, 02:39 PM
  4. Function to Generate Random Numbers and Letters
    By jason_kelly in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-14-2010, 03:39 PM
  5. [SOLVED] Need to generate random values from a list
    By Sumeet Benawra in forum Excel General
    Replies: 2
    Last Post: 07-13-2006, 07:15 AM
  6. [SOLVED] generate a random number and use if function to generate new data
    By Dogdoc1142 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-25-2006, 10:50 PM
  7. [SOLVED] Generate random numbers between two values and with a given mean
    By pinosan in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-07-2005, 10:06 AM

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