So, have you ever highlighted rows in Excel?. This gives us our TRUE or FALSE test to enable Excel to decide to format our cells or not. So MOD takes the ROW number and divides by 5 and gives us the remainder.
This is the number representing the ‘nth’ rows to format. The ROW function simply returns the row number for a reference. So, MOD is often seen in formulas that deal with “every nth” value. divisor – The number to divide with.įor Example, MOD(3,2) returns 1, because 2 goes into 3 once, with a remainder of 1. The Excel MOD function returns the remainder of two numbers after division.
If not then here is a bit more information about it to make it a bit clearer. So, we used the MOD Function to solve this query from one of my subscribers.
