We rebuilt the editor. Less panel hunting. More shaping.

Guide

How To Divide In Google Sheets

This guide will show you how to perform division in Google Sheets. Follow these easy steps to divide one number by another in your spreadsheet.

Interactive tour · Open canonical tour

  1. Use the division formula: =A1/B1 to divide the value in cell A1 by B1.

  2. Press Enter to apply the formula.

  3. Drag the fill handle down to apply the formula to multiple rows.

  4. Use =DIVIDE(A1, B1) as an alternative function for division.

  5. Ensure the denominator is not zero to avoid errors.

  6. Use IFERROR(A1/B1, "Error") to handle division errors.

  7. Format the result as a percentage if needed.