In the WPS table, if you need to divide a number into the sum of multiple random numbers, you can use the SUMPRODUCT and randomize functions together.The specific steps are as follows: 1. Put the number to be split into cell A1 and name it sum. 2. Enter the following formula in another cell: =SUMPRODUCT(A7:A30,A7:A30,A7:A30)/6 Among them, A7: A30 represents the range to be split, which can be adjusted according to the actual situation. 3. Insert a "generator" beside the formula by clicking Insert ->Module ->Inserted Module ->Select randomize ->Click OK.A random number window is generated. 4. Enter the number of numbers you want to generate in this window and click OK.A generator array is automatically generated. 5. Copy and paste the generator array and the previously set formula to get the desired result. The above method is to use the SUMPRODUCT and randomize functions to divide a number into the sum of multiple random numbers.I hope it can help you!
Step 1: A1 input 100 Step 2: B1 to B25 input rand() function respectively to get 25 random numbers Step 3: B26=SUM (B1: B25) Step 4: C1 input B1/B26 to get the ratio of B1 to B26, and then fill it down to C25 to get the ratio of column B to B26 Step 5: Multiply A1 in column D by the corresponding ratio in column C.
1. Put adjustment factors 0.5 and 1 in A1 and A2 2. Place the number 100 to be disassembled in C1 3. Place the number of splits in D1 25 The next operation is related to the number of previous steps. Here, 25 is taken as an example 4. Put 1 to 25 as the serial number from B2 to B26 5. Fill in C2=C1-RANDBETWEEN (1, (C1 - $D $1+B2) * $A $2/POWER ($D $1+1-B2, $A $1)) And pull down to C25, fill 0 in C26 The basic idea of this step is to make a man a random number, let him subtract 100 from his number, and then split it into 24 numbers. Repeat until there is only one number left, so C26 is 0 instead of continuing to split It is considered here that every random number is a positive integer. If 0 can be taken, the lower limit 1 in the formula will be changed to 0 If it can not be an integer, change the function to =C1-RAND()*(C1-$D$1+B2)*$A$2/POWER($D$1+1-B1,$A$1) 6. Fill in D2=C1-C2 And pull down to D26 7. This is the end. Double click a cell and press Enter to update the data 8. If you are not satisfied with the result, you can adjust the coefficient The adjustable range of A1 is 0 to 1, and the range of A2 is related to A1. The value of A2 is better around (A1+0.5), so you can try it yourself
If this does not work, it will cause data cycle errors. You can hide this column, and then enter a formula on other columns. For example, column A can be hidden by multiplying a number. Enter=A1 * a number in B1, and then copy the formula to the bottom.
