Use of division formula in excel table

Use of division formulas in excel tables

1. The symbol "/" is used in Excel tables to represent the division sign. , please note that it must be the slash symbol entered under the English input method.

For example, A1 divided by B1 is A1/B1.

2. Unlike the plus sign, division does not have a separate function.

3. The specific operation method is as follows:

(1) Open the excel document;

(2) Select a cell and type the divisor to the right of "fx" With the dividend, such as "A1/B1"; here is the quotient of A1 divided by B1.

(3) Press the "Enter" key to get the ratio;

(4) Move the mouse to the lower right corner of the cell until the mouse changes to a small black cross;

(5) Pull down the cell and get a series of ratios, that’s it.

The rest of the common symbols in Excel are as follows:

1. Addition is " ", or use the function symbol "sum";

2. Subtraction is " -";

3. Multiplication is "*".

For more Excel-related technical articles, please visit the Excel Basic Tutorial column!

The above is the detailed content of Use of division formula in excel table. For more information, please follow other related articles on the PHP Chinese website!