Chương 6 Xây dựng công thức và chức năng Bạn đã sẵn sàng để bắt đầu tạo ra các bảng tính mạnh mẽ và hữu ích bằng cách xây dựng các công thức của riêng mình? Chương này sẽ giải thích các công thức, cho thấy bạn làm thế nào để xây dựng chúng, và cho thấy bạn làm thế nào để kết hợp các chức năng bảng tính linh hoạt của Excel vào công thức của bạn. | Building Formulas and Functions Are you ready to start creating powerful and useful worksheets by building your own formulas This chapter explains formulas shows you how to build them and shows you how to incorporate Excel s versatile worksheet functions into your formulas. You also learn useful formula techniques such as how to sum a row or column of numbers how to create quick formulas using the AutoSum feature how to use range names and range from other workbooks in your formulas and how to move and copy formulas. Understanding Excel Formulas Build a Formula 114 Understanding Excel Functions Add a Function to a Formula 118 Add a Row or Column of Numbers 120 Build an AutoSum Formula 122 Add a Range Name to a Formula 124 Reference Another Worksheet Range in a Formula 126 Move or Copy a Formula 128 Understanding Excel Formulas To get the most out of Excel you need to understand formulas so that you can perform calculations on your worksheet data. You need to know the components of a formula you need to understand arithmetic and comparison formulas and you need to understand the importance of precedence when building a formula. Formulas A formula is a set of symbols and values that perform some kind of calculation and produce a result. All Excel formulas have the same general structure an equal sign followed by one or more operands and operators. The equal sign tells Excel to interpret everything that follows in the cell as a formula. For example if you type 5 8 into a cell Excel interprets the 5 8 text as a formula and displays the result in the cell 13 . Operands Every Excel formula includes one or more operands which are the data that Excel uses in the calculation. The simplest type of operand is a constant value which is usually a number. However most Excel formulas include references to worksheet data which can be a cell address such as B1 a range address such as B1 B5 or a range name. Finally you can also use any of Excel s built-in functions as an operand. .
