Office hacks: Excel to quickly find the least common multiple or the largest convention

In research, work or life, it is sometimes necessary to find the greatest common multiple or the greatest common divisor between different numbers. The least common multiple must be divisible by all the data involved, which is often used in scientific research such as gearing and planetary alignment, while the greatest common divisor can divide all the data calculated by the parameters, which is often used in working life such as origami assembling and carpentry. If the traditional manual method is used, the calculation will be very complicated when there are more data involved in the calculation. With the help of Excel or WPS table function, you can easily seek the results.

1. in Excel to find the least common multiple or the greatest common divisor

In Excel to find the least common multiple, you can use the LCM function; and the maximum number of conventions can be used to find the GCD function. To obtain from cell A1 to cell A6 between the minimum common multiple of data and the maximum number of conventions to illustrate. If you want to write the results of the least common multiple of these six numbers into cell C2, click on cell C2, and then enter the formula “= LCM (A1: A6)”, press the Enter key will be able to see the results of the calculation 8400 (Figure 1).

2001A-GYGB-1

Similarly, if you want to write the results of the above six data of the largest convention into cell D2, simply construct the function “= GCD (A1: A6)” in cell D2, you can get the results of the calculation of 50 (Figure 2).

2001A-GYGB-2

So, if you only need to find the least common multiple or the greatest common divisor between several of the discontinuous data, how do you construct the formula? In fact, if the data involved in the calculation is not much, just change the range of expression in the formula to a half-comma spaced by the data list can be. For example, to get in cell C2, A1, A3, A5, the three numbers of the least common multiple, just write the formula in cell C2 “= LCM (A1, A3, A5)” can be (Figure 3).

2001A-GYGB-3

Similarly, if the cell in D2 to take A2, A3, A6, a total of three data the maximum common divisor, you only need to construct the formula in cell D2 “= GCD (A2, A3, A6)”.

Tip: Be sure to pay attention to the formula in the brackets, separator are required for the English half-angle symbols, if the input is mistakenly written as a full-angle characters, there will be an error message.

2. in the WPS form for the least common multiple or the greatest common divisor

WPS form for the smallest common multiple and the maximum convention used in the function and Excel function is basically the same. In the WPS form, the use of insert function command, we can more intuitively see the specific use of the function in real time, so as to achieve the purpose of accurate application.

For example, to obtain the minimum common multiple of the above six numbers, simply locate the results of cell C2, and then click on the “Formula ¡ú Insert Function” menu button, enter LCM in the Find Function box, you can see the function given by WPS to use the format. Determine, according to the tips given by the wizard, specify the range of cells to be taken, you can get the results of the calculation (Figure 4).

2001A-GYGB-4

QQ图片20210420165237

Leave a Comment