9/7/2023 0 Comments Openoffice calc text function![]() ![]() ![]() You can use this function to control error values in certain cells. Returns TRUE if the value refers to any error value except #N/A. If an error occurs, the function returns a logical or numerical value. A cell with a formula inside is not empty. This function is used to determine if the content of a cell is empty. Returns TRUE if the reference to a cell is blank. If no formula cell can be found, or if the presented argument is not a reference, returns the error value #N/A. The formula will be returned as a string in the Reference position. If r eference is missing, Calc uses the position of the cell in which this formula is located.Ĭalculates the current value of a formula at the actual position.ĭisplays the formula of a formula cell at any position. If r eference is a range, the cell reference moves to the top left of the range. Reference is the address of the cell to be examined. Info_type is not case sensitive, but it must be enclosed within quotes. Info_type specifies the type of information to be returned and comes from a predefined list of arguments. Returns information on a cell such as its address, formatting or contents of a cell based on the value of the info_type argument. These functions provide information (or feedback) regarding the results of a test for a specific condition, or a test for the type of data or content a cell contains. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |