A simple tutorial on correctly inputting fractional forms in Excel and being able to participate in calculations

A simple tutorial on correctly inputting fractional forms in Excel and being able to participate in calculations Correctly determining the form of input fractions and participating in calculations in Excel is a common problem that many users encounter. PHP editor Apple has compiled some simple and easy methods to help readers easily cope with this challenge. Through this tutorial, readers will learn how to correctly enter fractional forms in Excel and master how to perform basic operations, making Excel's processing of fractional data more efficient and accurate.

1. Open the Excel table, enter 11/19 in the cell, and after pressing enter, the cell displays 4/7, which is not the fraction form we want.

2. How to enter a fraction with an integer part, for example, enter 3 and 3/7, enter the integer 3 in the cell, and then enter spaces, 3/7, Then what you see is the fraction form. The number 3.42857... is still displayed in the edit column, and it can participate in calculations.

3. How to enter a fraction without an integer part? For example, enter 1/5, enter 0, a space, then enter 1/5, and then the fraction 1/ will be displayed. 5 and 0 are automatically hidden.

4. If the entered fraction is a numerator and denominator whose common divisor is 2 or above, for example, if you want to enter 3/9, enter 0, a space, and 3/9, and then see the display is 1/3, Excel will automatically perform reduction processing and display it in its simplest form. If the input is 9/3, it will be displayed as the integer 3.

5. If you enter a fraction whose numerator is larger than the denominator, for example, enter 19/5, first enter 0, then enter a space, 19/5, we will see the cell What is shown here is 3 and 4/5 (3 4/5). Excel will automatically perform the calculation and display it as an integer proper fraction.

6. Next, enter the fractions 2 2/7 and 3 3/5 in cells B5 and B6 respectively, and find the sum of B5 and B6 in cell B7. Then we can see The sum is 5 8/9.

The above is the detailed content of A simple tutorial on correctly inputting fractional forms in Excel and being able to participate in calculations. For more information, please follow other related articles on the PHP Chinese website!