![]() =OFFSET(B1 H1 H2 H3 H4) where cells H1 to H4 contain the numbers 1.2, 2.9, 3.5, and 4.7 respectively. The OFFSET function therefore returns a reference to cell C3 and the formula returns the content of that cell. The Height and Width arguments are omitted and assume the default values of 1. Here the function determines the cell that is two rows below and two columns to the right of cell A1. =OFFSET(A1 2 2) where cell C3 contains the string "LibreOffice" (entered without quotation marks). This means that Calc will update the reference returned by OFFSET when any cell is updated by selecting Data ▸ Calculate ▸ Recalculate or pressing F9, or on any input event. Otherwise, OFFSET returns a reference to a cell range.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |