How to use excel to do like add, subtract, multiply, in addition to computing?
[Users questions | Browse:45 | Favorites]
Users questions:
Experts answer: Let me talk about Canada, you have options to attend one column or row operations data, and the choice under the column or the row over the election, after a cell, and then click the Tools bar, "sigma" symbol, can automatically sum. You can also use the formula. Need to put the calculation results of the selected cell, click"Sigma" symbol, in which the cell appears in "SUM (... ...)", to eliminate the contents of brackets, parentheses should be retained, hold down the "Ctrl" key and click with the mouse cells selected to participate in operations , optional entire column, the whole line, but also have a choice election, it is convenient, the election can be exhausted tap Enter. ItsI (subtract, multiply, divide), you can refer to just the sum formula, namely, "SUM (... ...)" in parentheses, enter operations cell to attend the names and computing symbols, such as "SUM (A1-B2 - A3-A6) "This is a minus one" - "for minus; such as" SUM (A1 * A3 * A5 * B1 * B2 * C4) "This is a ride where" * "represents multiplication; such as" SUM (A1 * A2) ", where" * "that, apart from numbers. If you think that this trouble, you can be selected into the calculation of the results of the cell, in the cell directly into the content of double-quotes "= A1-A3" knock backCar keys can be, double quotes do not enter. Similarly, that "-" No. You can become "+**", add multiplication and division. A1, A2 to participate in computing the data indicated that the cell address where you can enter. Give it a try.
Experts answer: Let me talk about Canada, you have options to attend one column or row operations data, and the choice under the column or the row over the election, after a cell, and then click the Tools bar, "sigma" symbol, can automatically sum. You can also use the formula. Need to put the calculation results of the selected cell, click"Sigma" symbol, in which the cell appears in "SUM (... ...)", to eliminate the contents of brackets, parentheses should be retained, hold down the "Ctrl" key and click with the mouse cells selected to participate in operations , optional entire column, the whole line, but also have a choice election, it is convenient, the election can be exhausted tap Enter. ItsI (subtract, multiply, divide), you can refer to just the sum formula, namely, "SUM (... ...)" in parentheses, enter operations cell to attend the names and computing symbols, such as "SUM (A1-B2 - A3-A6) "This is a minus one" - "for minus; such as" SUM (A1 * A3 * A5 * B1 * B2 * C4) "This is a ride where" * "represents multiplication; such as" SUM (A1 * A2) ", where" * "that, apart from numbers. If you think that this trouble, you can be selected into the calculation of the results of the cell, in the cell directly into the content of double-quotes "= A1-A3" knock backCar keys can be, double quotes do not enter. Similarly, that "-" No. You can become "+**", add multiplication and division. A1, A2 to participate in computing the data indicated that the cell address where you can enter. Give it a try.
- There are several new methods of presentation, simply out of.
- What word in how to increase the special symbols
- excel how to filter and distinguish between the number of consecutive
- How will the characters in the cell and breakdown of figures show?
- How to set excel in the integer "0" format
- How to convert PDF text editable word or TXT
- How could such a problem?
- Help explain, EXCEL function of usage, there are accessories.
- Why not let me see My Network Places?
- EXCEL delivery table and more, how do
- This information provided by the users.Thanks!
Computer Knowledge Copyright 2005-2015 All Rights Reserved.