Excel program development methods

How to develop excel program

How to write small programs in excel

1. First open Excel, take making a lottery applet as an example, and enter some data first.

#2. First, we enter =INDEX() in the cell of the lottery area.

#3. Then select the data source, that is, all members.

4. Then continue to enter =INDEX (E:E, Randbetween()).

5. Enter 1 and 5 in the Randbetween() function, which is the data source.

#6. After the input is completed, press Enter to confirm. Such a lottery mini program is now created.

#7. We only need to press the lucky one in f9 to switch.

Recommended: "excel tutorial"

The above is the detailed content of Excel program development methods. For more information, please follow other related articles on the PHP Chinese website!