Excel program development methods
- 藏色散人Original
- 2020-03-16 09:24:565606browse
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!
Statement：
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article：What is selected when you click a row label in a worksheetNext article：What is selected when you click a row label in a worksheet