How to Get Remainder in Google Sheets

To get the remainder in Google Sheets, you can use the MOD function. The MOD function returns the remainder after a number (dividend) is divided by a divisor. The syntax for the MOD function is:

MOD(dividend, divisor)

Here's a step-by-step guide on how to use the MOD function in Google Sheets:

  1. Open a Google Sheets document.
  2. Click on a cell where you want the remainder to be displayed.
  3. Enter the formula using the MOD function with the required dividend and divisor values. For example, if you want to find the remainder when 10 is divided by 3, you would enter the formula as =MOD(10, 3).
  4. Press Enter, and the remainder will be displayed in the selected cell.

Example

Let's assume you have the following data in Google Sheets:

| Column A | Column B |
|----------|----------|
|       10 |        3 |
|       15 |        4 |
|       20 |        6 |

You want to find the remainder for each row using the MOD function. Follow these steps:

  1. Click on an empty cell in a new column (for example, cell C1).
  2. Enter the formula using the MOD function and the appropriate cell references. In this case, you would enter the formula as =MOD(A1, B1).
  3. Press Enter, and the remainder for the first row will be displayed in cell C1.
  4. Click on the cell C1, and then move your cursor to the bottom right corner of the cell until it turns into a plus (+) sign.
  5. Click and drag the plus sign downwards to apply the formula to the other rows. The remainder for each row will be displayed in column C.

Now your Google Sheets document should look like this:

| Column A | Column B | Column C |
|----------|----------|----------|
|       10 |        3 |        1 |
|       15 |        4 |        3 |
|       20 |        6 |        2 |
Did you find this useful?