How does Excel use VBE to decompose decomposition? Objective: To decompose decomposition with Excel custom function.
1. For example, we want to decompose the seven-color dictionary order into decomposition.
2, into the VBE programming environment.
3, insert module.
4, write a program, do a name called "Prime" of the custom function.
5, close the VBE, insert the function in the cell.
6, select "User-defined", quickly find the function.
7, select the cell, apply the function.
8, the first step is completed.
9, again apply the function, the second step to calculate the results, that is, two times the result of decomposition.
10, the result of the third step calculation.
11, we know that 3 is prime, 431 also need to calculate one step. We get: 1599441=1237x431x3