Excel random numeric problem with the help of the experts.

Enter =round(rand()*a$1-2) in b1 and copy to the left.

a1 input any value, b1=randbetween(1,$a$1-2);

b2=randbetween(1,$a$1-$b$1-2);

b3=a1-b1-b2

This method will definitely work, I don't know if you are satisfied!

1. Open the excel software and create a new blank form.

2. Enter the raw data to generate a probabilistic random number. The raw data differs in the probabilities of plotting different awards. The generation of random numbers is determined based on the magnitude of the probability that indicates the winning state.

3. Randomly select a cell to define a fixed probability random number function.

4. Input = lookup(rand()*100,,) This is a combined formula that uses the lookup and rand functions to generate a fixed probability random number.

5. The following is a randomly generated fixed number. Even if it is probable, the effect is as follows.

1. First of all, enter the random function formula imitation family in the cell of excel**: =rand().

2. Click Enter to generate a random number, the size range of the data cannot be controlled, and it needs to be set within a certain range.

3. For example, if you need to set it between the number 5 and the number 15, you can input a random function: =rand()*15-5)+5.

4. Click Enter, you can generate the calculation result of the input formula, and you can see in the figure below that the generated random data is between 5 and 15.

You can directly use the randbetween function to generate a random number orange hole within a certain range.

The rand function can be used in combination with other functions to generate random numbers within a range of circles.

randbetween [syntax].

randbetween（bottom,top）

bottom parameter: The smallest integer that randbetween will return.

Top Parameter: The largest integer that randbetween will return.

Example: randbetween(1,100).

A random integer (variable) greater than or equal to 1 and less than or equal to 100

randbetween(-1,1)

A random integer (variable) greater than or equal to -1 and less than or equal to 1

Note: The randbetween function will only generate random integers. If you need random decimals, you can use them in combination with the RAND function.

In Excel version 2003 or later, enter =rand() directly in the cell

Get a random number greater than or equal to 0 and less than 1.

Examples of other build methods:

Generate a random number between A and B (a random number is entered in the first cell: =rand()*b-a)+a

For example, if the tremor generates a random number between 1 and 10, input: =rand()*9+1

For the remaining numbers, place the mouse in the lower right corner of the grid, and when it becomes a cross, drag it down.

Generate a random integer between a and b (a random number is entered in the first cell: =int(rand()*b-a)+a).

For example, to generate a random integer between 1 and 10, enter: =int(rand()*9+1).

For the remaining numbers, place the mouse in the lower right corner of the grid, and when it becomes a cross, drag it down.

Generate a random number between A and B (A random number B).

In the first box, enter =rand()*b-a+1)+a

For example, to generate a random number from 1 to 100, enter: =rand()*100+1

1. Use the randbetween function to produce a random numeric integer part of the range, the formula: =randbetween(minum, max);

2. Use the rand function to produce random numbers (decimal part), the formula =rand();

3. Use the round function to eliminate the number of decimal places, and the formula = round (the appreciation of the number of oranges, retain the significant number after the decimal point).

4. For example, if a random number between 0 and 100 is generated, the 2 significant digits after the decimal point are retained. The whole formula is:

round(randbetween（0,99)+rand(),2)<>

Please use the function randbetween to deal with it, and you can macro the problem to solve the problem.

Enter in A1: =Randbetween. Landslides such as:

=randbetween(111,999)

As a result, A1 will get a random number with any three digits between 111 and 999.

Enter the formula =randbetween(1,10000) and you will produce a random integer from 1 to 10000.

1. Create a blank excel;

2. Insert sample data of the start-end range;

Start Termination.

3. Enter the formula =d2+rand()*e2-d2 in cell G2 to generate random numbers in the range of 1-100;

4. Similarly, in the G column, other cell data formulas generate random numbers between -8 respectively;

You can use the Excel VBA to program this math problem by first defining an array arr from 1 to 70. Represent these 70 people. Then do a cycle of 1 to 245.

A random number from 1 to 70 is generated in each cycle. If 55 is generated, then arr(55) is added with 1Then look at how many of the values are 1 in this array.

How many values are there for 2? . . How many values are there for 10. How many values are there for 0.

This represents how many people got 1 coin, 2 coins, 0 coins... And so on. (0 coins are included here, slightly different if each person gets at least one.)

It's just that at the time of the cycle, it is between 1 and 245-70. Finally, just add 1 to the result. If each person gets a maximum of 10 coins, this will also be changed slightly.

That is, when arr(x)=10, the random number produces x again, so that he generates a random number again... I don't know what exactly you're asking for, so I didn't make it directly. I've given you the idea ...

You have a problem with this, how do you get 70 by adding from 1 to 10 and the maximum value is 45? If you are looking for the sum of a few of a group of numbers is equal to another number, I can give you a VBA, that is, 1-19 arbitrarily add (non-repeat) to get 70 There are more than 5000, how do you calculate such a huge number.

...To put it very clearly, this is like a problem of finding unknowns, not random numbers...

Material Tools: Excel2010

1. Open the copy.

Click on the "A1" cell (indicated by the red arrow in the figure) to see that the value is randomly selected in the "10-100" range using a formula (red box in the figure).

2. Let's take the fixed value in the area of "A1-D10" (red box in the figure) as an example, select the area, and press "Ctrl+C" on the keyboard to copy.

3. Right-click on the "A1" cell, and click "Paste Special" (indicated by the red arrow in the picture) in the pop-up menu

4. In the pop-up dialog box, check the dot before "Value" (indicated by the red arrow in the figure), and then click "OK" (indicated by the blue arrow in the figure).

5. Go back to the workbook, click the "A1" cell (pointed by the red arrow in the figure), you can see that its value has been fixed (blue box in the figure), so you can deduce that the "A1-D10" cell area (red box in the figure) has become a fixed value.

1. Open the excel software and create a copy.

Create a new blank form for bai.

2. Enter the raw data to generate a random number of probabilities. The difference in the raw data is in the probability of plotting different prizes. The generation of random numbers is determined based on the magnitude of the probability that indicates the winning state.

3. Randomly select a cell to define a fixed probability random number function.

4. Input = lookup(rand()*100,,) This is a combined formula that uses the lookup and rand functions to generate a fixed probability random number.

5. The following is a randomly generated fixed number. Even if it is probable, the effect is as follows.

Generate random numbers as needed with the random function rand (the current version also uses the randbetween function), and then right-click on the area where the formula has been used --copy-right-click--paste selectively--value, so that the formula is removed, and only the generated random data is kept, and it will not change again.

Enable iterative calculations so that the random formula references the cell itself.

For example: a1 input the following formula:

if(a1>,a1,rand())

As long as A1 is greater than , changing other cells will have no effect on the A1 result.

Use VBA to do **, or after the formula calculates the random number, turn off the automatic recalculation of **, and paste the value to other places every time the random number is calculated.

Du calculates the public dao display mode.

calculate'Manual calculations.

When solved with a formula, it will change if it is plagiarized. You can use functions with tricks such as a1:a10 to generate random integers from 1 to 10 in a1:

If you want to generate random numbers and save them, you can copy a1:a10, then select the area you want to paste to, right-click and paste selectively, select the value, and OK, then the data in column b is not a formula.

If you're just going to implement it in the same region.

Copy a1:a10, right-click and paste it selectively, select the value, and confirm, then it is no longer a formula.

A better approach is to handle it with macros, i.e. with VBA random generation, so that you run it once and generate a batch.

The easiest thing to do is to copy it, put it next to Paste the Point Value Selectively OK.