How to Express "Divisible By" in Excel

How to Express
••• Urupong/iStock/GettyImages

You can use the "divisible by" operation in Excel documents to solve problems such as uniformly allocating resources to a certain number of people. Even though this operation is not part of the list of standard operations, you can define it using two other functions, if and mod. These use the idea that if the remainder for the division of two numbers is 0, then the first number is divisible by the second.

    Launch your Microsoft Excel document. Locate the two numbers you want to check the divisibility property for and note the name of their corresponding cells. The name of a cell is composed of a letter and a number. For example, the first cell of the first row in your document is labeled "A1."

    Click on an empty cell in your document and type "=MOD(cell1,cell2)" (without the quotes) inside it, where cell1 and cell2 are the names of the cells holding the two numbers. Press "Enter" to compute the remainder for the division of the two numbers.

    Click on another empty cell and type "=IF(cell=0,'Divisible','Not divisible')" (without double quotes) inside it, where cell is the name of the cell holding the remainder of the division. Press "Enter." If the first number is divisible by the second one, Excel displays "Divisible" in this cell. if it isn't, the software shows the message "Not divisible."


    • You can combine the two expressions into a single one, so you don't have to use two cells to express the divisibility property. Type "=IF(MOD(cell1,cell2)=0,'Divisible','Not divisible')" (without double quotes) into an empty cell, where cell1 and cell2 are the names of the two cells holding the numbers.

Related Articles

How to Subtract Matrices on Excel
What Does ##### Mean in Excel?
How to Calculate Arctan
Subtracting Minutes From Time in Excel
How to Create Matrices on a TI-89
How to Calculate Correlation Coefficient Between Two...
How to Make a Fraction on a Scientific Calculator
How to Do Exponents on the TI-30XIIS
How to Make a Cell Model Styrofoam Ball
How to Write Notes on a TI-84 Silver Edition Calculator
How to Find Zeros of Functions in Excel
Multiplying Fractions
How to Calculate the Percent Change in Excel
How to Do Fractions on a TI-30X IIS
How to Divide Rational Numbers
Covariance Instructions on TI-83 Calculator
How to Do Factorials on a Scientific Calculator
How to Solve by Simpson's Rule With Excel
How to Make an Equal Sign on the TI-84 Plus Silver...
How to Make a Plant Cell Model Using a Shoebox

Dont Go!

We Have More Great Sciencing Articles!