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 Calculate Correlation Coefficient Between Two...
How to Subtract Matrices on Excel
How to Calculate Arctan
What Does ##### Mean in Excel?
How to Do Exponents on the TI-30XIIS
How to Create Matrices on a TI-89
Subtracting Minutes From Time in Excel
How to Find Zeros of Functions in Excel
How to Write Notes on a TI-84 Silver Edition Calculator
The Four Types of Multiplication Properties
How to Calculate the Percent Change in Excel
How to Write Math Arrays
How to Make a Fraction on a Scientific Calculator
How to Check My Math Answers
How Do I Calculate the Relative Standard Deviation...
How to Solve by Simpson's Rule With Excel
How to Calculate Pearson's R (Pearson Correlations)...
Multiplying Fractions
How to Graph a Distribution for a T-Test

Dont Go!

We Have More Great Sciencing Articles!