# In the self-Excel in a less mature ideas

In the first of a cell to determine a random number (example:A1 cell in the number is 10), called A2 to the A11, or B2 to B11 cells can be randomly generated to meet certain conditions of the number 10? Also A1 means that the cell is the number of “X”, in the “X” in a row of cells is generated random numbers?

= IF (ROW (A1)> 10, “”, RAND ())

to copy the formula down.A1 enter:

= INT (RAND () * 10) +1

A2 to A65535 are imported

= IF ($ A $ 1> (ROW () -1), INT (RAND () * 10) +1 ,””)

(Note :This is a random number from 1-10 the random number) in the A2 or B1 enter the formula:

= IF (ROW (1:1)> A $ 1, “”, RAND ())

formula will be to Under the copy.I think we can do! I'll give you my thinking:

all out in the B cell to write (all the same, a written copy drag on the line):if, if this cell line, less than or equal to the content of a1 Shows that the implementation of a random function of the number of conditions, or does not show (not shown he can show that space can also be an error, and then set up the error prevent excel cells show).

This less than or equal to 10 Cells have shown us that, no more than the show!

cell line, is the row ()

## Leave a Reply

You must be logged in to post a comment.