Saturday, January 28, 2012

How to Calculate Fractions in Excel 2007


1. Open the Excel spreadsheet you want to use to calculate fractions.
2. Click an empty cell and enter a number in decimal format, for example, '1.875.' Press 'Enter.' The number should show up exactly as you entered it.
3. Click the cell again and then click the 'Home' tab on the menu ribbon. Click the down arrow in the text formatting window in the 'Number' group. The text formatting window might display 'General' initially or something else. Click 'Fraction' from the drop-down list. The number displays as a fraction now.
4. Add, subtract, multiply, divide or otherwise create any equation using fractions in the formula bar. For example, to add two fractions, enter '=1/2 1/4.' Excel will display '3/4' in the cell if the cell is formatted as a fraction.

Blogger news