Excel Function : MOD

Download now!

Excel Function : MOD

Category

Math and trigonometry

Description

Returns the remainder from division

Microsoft Excel Reference Page

https://support.office.com/en-us/article/MOD-function-9b6cd169-b6ee-406a-a97b-edf2a9dc24f3

Syntax and Description of the MOD Excel Function

I am using this formula to pull data from an excel sheet using the MOD function. =MOD(ROW(A1:A6)-ROW(A1),6)+1 This formula works fine if I want to pull 6 rows at a time. But I want to pull 2 rows at a time. How can I change this formula to pull 2 rows at a time? A: For two rows at a time, you need to change your modulus to 2. =MOD(ROW(A1:A6)-ROW(A1),2)+1

About MOD Excel Function

The MOD function returns the remainder after a number is divided by a divisor. For example, MOD(9,3) equals 0 because 3 goes into 9 evenly nine times with no remainder. However, MOD(10,3) equals 1 because 3 goes into 10 seven times, with a remainder of 1.