How to Subtract Fractions

How to Subtract Fractions in Excel


Microsoft Excel are capable of solving fraction problems. This tutorial will show how to subtract fractions.
 

Steps


1. Input the fractions as a regular formula in individual cells. Excel will automatically convert it to decimal format. For example =1/2 will yield 0.5 in a cell.
2. Subtract the numbers using cell reference separated by - symbol. Again Excel will convert it into a decimal formal.
3. Select the cells where you want to convert to fraction format, then format cells (can be accessed by either right-clicking or from the ribbon menu). A small window will pop out, then select 'Number' tab, choose 'Fraction' and press 'OK'.

Watch the screen recording below for demonstration.

 
How to Subtract Fractions
 
You might also want to learn how to divide fractions, see our next tutorial.
 
Show Comments
 

About Us

Excelcrib was founded in November 2017 by Garry, a Microsoft® Office Excel® (MS Excel) enthusiast with background in engineering. He's been using MS Excel for more than 15 years in practice with specialty in VBA.

© Copyright 2023 Excelcrib | Privacy Policy

We use cookies to improve your browsing experience.
Continuing to use this site means you agree to our use of cookies.
Tell me more!