Office software is closely linked to the PDF,the PDF is also must have to control!
Set home Page Add to Favorites
|
three, INDIRECT, OFFSET 1, INDIRECT used to return the text string designated by the reference. When the need to change the formula cell references, not to change the formula itself, the use of function INDIRECT. The form of its syntax: INDIRECT (ref_text, a1) Ref_text for which the reference cell, the cell can contain a reference to A1-style, R1C1-style references, defined as the reference's name or text string to the reference cell. Ref_text is not legitimate if the cell references, INDIRECT function returns an error value # REF!. A1 is a logical value of the specified cell are included in the quoted ref_text type. If a1 is TRUE or omitted, ref_text be interpreted as an A1-style references. If a1 is FALSE, ref_text be interpreted as an R1C1-style references. Need to pay attention to is: If ref_text is a reference to another workbook (external reference), then the workbook must be open. If the source workbook is not open, INDIRECT function returns an error value # REF!. 2, OFFSET function to specify the references used for the frame of reference will be offset by giving the new references. Return to the quote can be a cell or range, and can specify the number of rows to return, or the number of rows. The form of its basic syntax: OFFSET (reference, rows, cols, height, width). Of which, reference offset variable frame of reference as the reference region (reference must be connected to the cell or range reference, or else, OFFSET function returns the error value # VALUE!). variable rows that frame of reference in relation to offset the upper-left corner of the cell upward (downward) shift in the number of rows (for example, the use of 2 as a parameter rows that reference the target cells in the upper left corner of the region lower than the reference line 2), line can be positive (on behalf of the initial quote in the bottom of the cell) or negative (on behalf of the initial quote in the top of the cell) or 0 (on behalf of the initial reference cell). cols that frame of reference in relation to offset the upper-left corner of the cell to the left (right) offset the number of rows (for example, the use of 4 as a parameter cols that references the target cells in the upper left corner of the region than the reference shifted to right 4), out can be a positive number (on behalf of the initial quote in the right side of the cell) or negative (on behalf of the initial quote in the left side of the cell). If the number of rows or columns offset beyond the edge of the worksheet, OFFSET function will return an error value # REF! . highly variable height, that is, by reference to the region to return to the number of rows (height must be a positive number). said width of variable width, that is, by reference to the region to return to the number of rows (width must be a positive number). If you omit the height or width, is the assumption that the width and height or the same reference. For example, the formula OFFSET (A1, 2,3,4,5) than that on cell A1 and right under the line 2 of the 4 line three of the five regions (that is, D3: H7 region). It can be seen, OFFSET function does not actually move any cells or change the selected area, it just returns a reference. |
