How to divide in excel

Excel division operation method: first open the table and create a new worksheet; then edit the numbers, select the cell in column C and enter the formula [=B1/A1] in the edit bar; finally press [ctrl and enter Key] to fill in the cells in column C to complete.

The operating environment of this article: Windows 7 system, Microsoft Office Excel 2018 version, Dell G3 computer.

Excel division operation method:

1. Open the computer, find and double-click the excel2018 version to create a new worksheet;

2. After clicking to open a new excel worksheet, for the purpose of demonstration, edit the total number in column A and the quantity in column B;

3. After editing the numbers, select Cell in column C and enter the formula =B1/A1 in the edit bar;

#4. After entering the formula, press "ctrl and enter" at the same time. Fill the cells in column C to complete.

Related learning recommendations: excel tutorial

The above is the detailed content of How to divide in excel. For more information, please follow other related articles on the PHP Chinese website!