Tech Note: the formula is pretty straightforward, and uses two built-in functions. • The
mod() function performs a modulo operation, whose result is the remainder of a division.
row() function returns the current row index (first row =
1, second row =
• We pass to the
mod() function two values (called "arguments") - the current row index (given to us by "
row()"), to be divided by the second argument, which is "
• The first equal sign just tells Excel that the text is a formula to evaluate, not a value.
• The second equal sign tests if the remainder is equal to "