Excel Function : MOD

Download now!

Excel Function : MOD


Math and trigonometry


Returns the remainder from division

Microsoft Excel Reference Page


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.