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

What Does ##### Mean in Excel?
How to Subtract Matrices on Excel
How to Calculate Correlation Coefficient Between Two...
How to Find Zeros of Functions in Excel
How to Create Matrices on a TI-89
Subtracting Minutes From Time in Excel
How to Do Exponents on the TI-30XIIS
How to Calculate Arctan
How to Write Notes on a TI-84 Silver Edition Calculator
How to Solve by Simpson's Rule With Excel
How to Work Out Percentages in Excel
How to Calculate the Percent Change in Excel
How to Calculate Pearson's R (Pearson Correlations)...
How to Make a Cell Model Styrofoam Ball
How to Graph a Distribution for a T-Test
How to Make a Fraction on a Scientific Calculator
How to Do Factorials on a Scientific Calculator
How to Do Algebra on a Ti-30Xa
How to Find Correlation Coefficient & Coefficient of...

Dont Go!

We Have More Great Sciencing Articles!