tailieunhanh - formulas and functions with microsoft excel 2003 phần 7

: Giá trị của tài sản đó vào cuối của khấu hao. cuộc sống: Số lượng thời gian mà tài sản khấu hao. mỗi: Thời gian. bình quân phải sử dụng các đơn vị tương tự như cuộc sốngTrong ô B1 nhập vào các chi phí mua. | Use the INDIRECT function to copy cell values from different worksheets The INDIRECT function can also be used to address cells in other worksheets and copy their values to the current sheet. Column A lists the names of worksheets and column B lists cell references. With the INDIRECT function the value of each cell reference can be copied to the current worksheet. To copy cell values of different worksheets 1. In a worksheet copy cells A1 B10 as shown in Figure 9-14. 2. Select cells C2 C10 and type the following formula INDIRECT A2 B2 . 3. Press Ctrl Enter . C2 2J INDIRECT A2 B2 A B c I D 1 worksheet cell reference value 2 sheets D1 team c 3 sheet B1 0 4 Sheets A5 38684 5 Sheet9 A3 HA 6 Sheetio A1 indicator 7 Sheetl 1 A2 8 Sheet12 B1 7 9 Sheet13 A4 Sheets 10 Sheet14 A5 56 11 Figure 9-14 Lookup and Reference Functions 229 Use the INDEX function to determine the last number in a column Sometimes it is very useful to let Excel automatically determine the last value in a list. Use the INDEX function in combination with COUNTA and COUNTBLANK to determine the last number in a column. The INDEX function returns the value of an element in a table or an array that is selected by the row and column number indexes. INDEX array row_num column_num array A range of cells or an array constant. row_num Indicates the row in an array from which a value will be returned. If omitted column_num is required. column_num Indicates the column in an array from which a value will be returned. If omitted row_num is required. To determine the last number in a column 1. In cells A2 A11 list any kind of numbers. 2. Select cell C1 and type the following formula INDEX A A COUNTA A A COUNTBLANK A1 A11 1 . 3. Press Enter . Figure 9-15 230 Chapter 9 Use the INDEX and COUNTA functions to determine the last number in a row In the previous tip we learned how to determine the last value for each column. Use the INDEX function in combination with COUNTA to determine the last number in a row. The INDEX .