Current location - Training Enrollment Network - Mathematics courses - How to enter one-half and three-quarters of the mathematics in the table in Excel?
How to enter one-half and three-quarters of the mathematics in the table in Excel?
1. Integer bit+space+fraction Example: To enter one half, you can enter: 0 (space)1/2; If you want to enter one and a third, you can enter: 1 (space) 1/3. Advantages and disadvantages of this method: it is convenient to input scores in this way, which can be calculated, but it is not beautiful enough (because we often express scores vertically, the input is not in line with our reading habits). 2. Example of using ANSI code input: To input half, you can press and hold the "Alt" key, then input "189", and then release the "Alt" key ("189" needs to be input with a small keyboard, but the keyboard input is invalid). Advantages and disadvantages of the method: it is inconvenient to input, it is not easy to know what the ANSI code of each value represents, and the input value cannot be calculated. But the scores input by this method are more beautiful, and some unusual symbols and units can be input by this method. With the help of Excel, there is an introduction of using this input method to input currency symbols. 3. Example of setting cell format: To enter one half, you can select a cell, use menu format/cell format, select "Classification" as the score, and the type is "Denominator is one bit". After the setting is completed, enter 0.5 in this cell to display "1/2". Advantages and disadvantages of the method: same as the first method. 4. Using Microsoft Formula Input We can use the menu "Insert/Object" to find "Microsoft Formula 3.0" in the object type, and click [OK] to display the formula editor (the formula editor needs to be installed customized, and if it is not installed, you will be prompted to put it on the Office installation CD, just follow the prompts). We can input scores just like using the formula editor in Word. Advantages and disadvantages of the method: the input is very beautiful and easy to typeset, which conforms to the habit of writing scores in daily life, but the input scores cannot be calculated. 5. Example of custom input method: To input half, first select a cell, use menu format/cell, select custom in the number category, and then enter # (space) /2 in the type. Advantages and disadvantages of the method: same as the first input method. This method can easily convert many existing numerical values into fractions with the same denominator. 6. Double-line integration This method takes the bottom border of the table as the horizontal bar of the score, inputs the numerator in a cell, sets the cell as the bottom border, and inputs the denominator in the next cell in the same column. For the sake of beauty, we can set other cells to be borderless, and then set the background fill color to white. Advantages and disadvantages of the method: the input is convenient and beautiful, but the score cannot be calculated.