How to input division in excel?
Division in Excel is represented by "/". The usage is as follows:
1. Open an example workbook and enter the operation result in the result column.
2, enter an equal sign "=" in cell "C2", and then click on the dividend "100" (pointed by the red arrow in the picture).
3. Enter the division sign "/" (red box in the picture) from the keyboard. This division sign is what many friends are unclear about. Then the formula in the cell It becomes as shown in the blue box:
4, click on the divisor "5" (pointed by the red arrow in the picture), and press the Enter key on the keyboard.
5, then the operation result of "100÷5" is "20" (pointed by the red arrow in the picture).
6. For other data to be calculated, you can click on the "C2" cell and move the mouse pointer to the lower right corner of the cell. A cross mark will appear (red in the picture). arrow points).
#7. Press the left mouse button on the cross mark and drag it down.
#8. After dragging to the corresponding position, release the left mouse button, and all data calculations will be completed.
For more Excel-related technical articles, please visit the Excel Basic Tutorial column!
The above is the detailed content of How to enter division in excel. For more information, please follow other related articles on the PHP Chinese website!