- MS Excel Basics
- Excel - Home
- Excel - Getting Started
- Excel - Explore Window
- Excel - Backstage
- Excel - Entering Values
- Excel - Move Around
- Excel - Save Workbook
- Excel - Create Worksheet
- Excel - Copy Worksheet
- Excel - Hiding Worksheet
- Excel - Delete Worksheet
- Excel - Close Workbook
- Excel - Open Workbook
- Excel - Context Help

- Editing Worksheet
- Excel - Insert Data
- Excel - Select Data
- Excel - Delete Data
- Excel - Move Data
- Excel - Rows & Columns
- Excel - Copy & Paste
- Excel - Find & Replace
- Excel - Spell Check
- Excel - Zoom In-Out
- Excel - Special Symbols
- Excel - Insert Comments
- Excel - Add Text Box
- Excel - Undo Changes

- Formatting Cells
- Excel - Setting Cell Type
- Excel - Setting Fonts
- Excel - Text Decoration
- Excel - Rotate Cells
- Excel - Setting Colors
- Excel - Text Alignments
- Excel - Merge & Wrap
- Excel - Borders and Shades
- Excel - Apply Formatting

- Formatting Worksheets
- Excel - Sheet Options
- Excel - Adjust Margins
- Excel - Page Orientation
- Excel - Header and Footer
- Excel - Insert Page Breaks
- Excel - Set Background
- Excel - Freeze Panes
- Excel - Conditional Format

- Working with Formula
- Excel - Creating Formulas
- Excel - Copying Formulas
- Excel - Formula Reference
- Excel - Using Functions
- Excel - Builtin Functions

- Advanced Operations
- Excel - Data Filtering
- Excel - Data Sorting
- Excel - Using Ranges
- Excel - Data Validation
- Excel - Using Styles
- Excel - Using Themes
- Excel - Using Templates
- Excel - Using Macros
- Excel - Adding Graphics
- Excel - Cross Referencing
- Excel - Printing Worksheets
- Excel - Email Workbooks
- Excel- Translate Worksheet
- Excel - Workbook Security
- Excel - Data Tables
- Excel - Pivot Tables
- Excel - Simple Charts
- Excel - Pivot Charts
- Excel - Keyboard Shortcuts

- MS Excel Resources
- Excel - Quick Guide
- Excel - Useful Resources
- Excel - Discussion

# Find the lowest common denominator or greatest common factor in Excel

We have used the lowest common denominator and greatest common factors we are students. However, if there are more big numbers, doing this will be complicated. Greatly Excel provides some functions to get the lowest common denominator or greatest common factor of numbers.

## Finding the Lowest Common Denominator of some numbers in Excel

**Lowest Common Multiple**

The Lowest Common Multiple or LCM of a set of numbers is the smallest common multiple of those integers. This means all those numbers to be divisible by the LCM giving an integer value. LCM is useful for calculating problems related to gears and planetary alignment.

Kindly apply the LCM function to the given numbers in order to find the lowest common denominator to the given numbers.

**Step 1**

Open an Excel workbook and enter the numbers in the cells as per your wish. Now enter the formula **=LCM(B1:B2)** in the blank cell as shown in the below screen shot.

**Step 2**

After pressing the **Enter **key, you will be able to calculate the least common denominator between all the numbers in the range of cells.

## Finding the Greatest Common Factor of Numbers in Excel

**Greatest Common Factor/Divisor**

The Greatest Common Divisor or GCD is the highest integer number that could be used to divide the set of numbers and gives you an integer value.

Using the GCD function will enable you to calculate the greatest common factor of several numbers if you need to find the common factor between them.

**Step 1**

Open an Excel workbook and enter the numbers in the cells as per your wish. Now enter the formula **=GCD(G1:G4)** in the blank cell as shown in the below screen shot.

**Step 2**

After pressing the **Enter** key, you will be able to calculate Greatest Common factor between all the numbers in the range of cells.

**Note**

It is important to understand that in the above formulas, B1:B2 indicate the range of cells, of the number that you want to calculate the LCM or GCD.

Ensure that all values are in the same column, it is important for them to be in the same row.

The formula would work regardless of whether you miss a cell or two in a column as long as the first and last cells are the same in both columns.

- Related Articles
- Return the greatest common divisor and lowest common multiple in Numpy
- Greatest common divisors in Python
- C program to find Highest Common Factor (HCF) and Least Common Multiple (LCM)
- Greatest Common Divisor of Strings in Python
- Haskell Program to calculate the Lowest Common Multiple
- C++ Program to Find Lowest Common Ancestor in a Binary Search Tree
- Lowest Common Ancestor of a Binary Tree in Python
- Lowest Common Ancestor of Deepest Leaves in Python\n
- Print the kth common factor of two numbers
- Haskell Program to calculate the Highest Common Factor
- Largest Component Size by Common Factor in C++
- Program to find out the lowest common ancestor of a binary tree using Python
- Lowest Common Ancestor of a Binary Search Tree in Python
- Program to find HCF (Highest Common Factor) of 2 Numbers in C++
- Find the highest common factor of;$7x^2yz^4, 21x^2y^5z^3$