Users who are used to working with formulas in the Excel Excel table processor from Microsoft sometimes try to find a ready-made function for dividing one number by another. But there is no such function, and it’s also impossible to use the colon sign - it is designed in Excel to indicate the boundaries of ranges. The division formula in Excel is just a backslash character (/).
How to divide one number into another
On the worksheet of the Excel book, enter any two numbers in different cells. They will help you figure out how to make the division formula in Excel. Then in a free cell, type the start sign of the formula (equal to =) and specify the first cell with the dividend. Next, type the division sign in the Excel formula - the backslash - and specify the cell with the divider.
, , 0, «» : #/0!.
! , . , , «#!», .
. «01.01.2017» «01.01.2016». , ? . , «» , 01 1900 . «01.01.1900» - 1, «02.01.1900» - 2. , «» «». , 1 2017 – 42736, 1900 . .
| C | D | E |
9 | 01.01.2017 | 01.01.2016 | 1,008638187 |
10 | 42736,00 | 42370,00 | 1,008638187 |
, , . «» Excel . .
«»
«», 2:6 , (3, 7, 9, 12, 15), 1:1 – , (1, 2, 3, 4).
, «». Excel . , , , – . , 2 «=$A2/B$1» ? . . , , D5. : «=$A5/D$1». .
. «» .
, , «». «» «», « » «». . , 7/3 2,333333333, 2,333. , , .
«» . «» «» – . .
«» – 7 3 ( D9 D10 ), – :
| D | E | |
9 | 7 | 2 | =(D9;D10) |
10 | 3 | 1 | = OSTAT (D9; D10) |
As you can see, the quotient of the division is two, the remainder is 1. In any free cell, enter the formula:
= E9 & "" & E10 & "/" & D10
Here the ampersand sign helps to attach the contents of another as text to the contents of one cell.
The result of this formula will be as follows: 2 1/3 - two integers and one third.
As you can see, the division formula in Excel is not a big deal. The main thing to remember is that when calculating formulas, Excel uses the standard rules of mathematics.