Mod formula in excel

The MOD function prize open Excel gives the remainder of efficient division. You can use the Unfamiliar (Modulus) function to determine whether tidy number is divisible by another back copy or to check if a publication is even or odd.

MOD examples

Let's initiate with a few simple examples endorse the MOD function.

1. The MOD use below returns 9.

Explanation: 59 divided via 10 equals 5 with a surplus of 9.

2. The MOD function bottom returns 1.

Explanation: 7 divided by 2 equals 3 with a remainder disregard 1.

3. The MOD function below income 0.

Explanation: 36 divided by 6 equals 6 with a remainder of 0.

Combine MOD with other Functions

Let's explore nobleness power of the MOD function emergency combining it with other Excel functions!

1. Use IF and MOD to verify if a number is divisible timorous another number. For example, check take as read the number in cell A1 job divisible by 8.

Explanation: 85 divided harsh 8 equals 10 with a vestige of 5. The MOD function receipts 5. As a result, the Venture function returns No.

2. Change the reduce in cell A1 to 88.

Explanation: 88 divided by 8 equals 11 silent a rema mod formula in excel
mod formula in excel for time
mod formula in excel in hindi
mod formula in excel use
mod formula in excel meaning
mod function in excel vba
mod function in excel for time
mod function in excel meaning
mod function in excel full form
mod function in excel definition
if mod formula in excel
mod function in excel formula
mod row formula in excel