The powerful Microsoft Excel spreadsheet processor easily multiplies any of your numbers and ranges. When can it really be useful in this regard? There are many options:
- There is no calculator at hand.
- Large ranges of numbers are multiplied, and you need to see which numbers are involved, and maybe replace some of them (in a conventional calculator without the function of saving the line, you will have to start the calculation again).
- Multiplication is only part of a complex formula.
As you can see, multiplication in Excel is a good thing. Virtually no formula can do without a multiplication operation.
Multiplication options in Excel
"Excel" allows you to multiply each other:
- Concrete numbers (positive, negative, integer, fractional).
- Numbers from the specified cells.
- Ranges of numbers.
- Boolean values
? Excel «» (=). , ( , ), «» (*). : «=0,22*-5*16» ( ), «=G4*I5» ( ). .
Excel «»:
|
|
|
| / 1; / 2; … / 255; | – . 255 ( ). |
Excel – , .
.
«»
«» :
| 1 | 2 |
|
|
A | B | C | D |
2 | 2 | 3 | =A2*B2 | 6 |
3 | 0,7 | -6 | =A3*B3 | -4,2 |
4 | | | =A4*B4 | 1 |
5 | | | =A5*B5 | 0 |
6 | | | =A6*B6 | 0 |
, Excel . , 0 () 1 ().
– , . , , - , «».
«».
«»
, Excel .
«» . , . «» , «».
| H | I | J | K |
| 1 | 2 |
|
|
12 | 2 | 6 | 9378270,72 | =(H12:H16;I12:I16) |
13 | 7 | 14,2 | 9378270,72 | =(H12:I16) |
14 | 5 | -2,7 | 9378270,72 | =H12*H13*H14*H15*H16*I12*I13*I14*I15*I16 |
15 | 0,26 | 4 | | |
16 | -10 | 56 | | |
«» , , . , «» , , , . , Excel – .
! , , . , , . «» . «» - , .
, , , . , «» .
, «» .
, Excel. .
| A | B | C | D | E |
1 | | 2 | 4 | 6 | 8 |
2 | 3 | =$A2*B$1 | 12 | 18 | 24 |
3 | 5 | 10 | 20 | 30 | 40 |
4 | 7 | 14 | 28 | 42 | 56 |
5 | 9 | 18 | 36 | 54 | =$A5*E$1 |
, – . , – «» ($) : «=$2*$1».