How to divide one column by another column in excel

There are many ways to divide one column by another column in Excel, including: using the formula (=C2/B2) using the "divide" function (=DIVIDE(C2, B2)) using "pivot" Table" function, drag the field you want to divide to the "Value" field area, drag the divisor field to the "Row Label" or "Column Label" field area, right-click the "Value" field, and select "Value Field Settings" ”, select the “Divide by” option in the “Show Value Decline” menu, and select the field to be divided by in the Divisor field box.

How to divide one column by another column in Excel?

Method 1: Use the formula

1. In the target cell, enter the formula: =C2/B2, where C2 is to be divided Cell, B2 is the divisor cell.
2. Press the Enter key.

Method 2: Use the "divide" function

1. In the target cell, enter the function: =DIVIDE(C2, B2).
2. Press the Enter key.

Method 3: Use "Pivot Table"

1. Select the data to be divided.
2. Go to the Insert tab and click PivotTable.
3. Drag the field you want to divide by to the "Value" field area.
4. Drag the divisor field to the "Row Label" or "Column Label" field area.
5. Right-click the Value field and select Value Field Settings.
6. In the "Show value drop-down" menu, select the "Divide by" option.
7. In the Divisor field box, select the field to divide by.
8. Click "OK".

Note:

• The divisor cell cannot be zero or blank.
• If the divisor cell contains text, the formula or function will return an error value.
• If you want to preserve the number of decimal places, use the ROUND() function. For example, to divide C2 by B2 to two decimal places, enter: =ROUND(C2/B2, 2).

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