Summary of information functions in Excel
To facilitate the selection of functions to suit the requirements when you need to process information in Excel spreadsheets. The following article summarizes the functions along with the functions of each function group in the Excel spreadsheet.
Please follow along!
CELL (info_type, reference): Function that returns information about the format, position or content of a cell.
ERROR.TYPE (error_val): The function returns the number corresponding to one of the error values in Excel or returns the # N / A error if there are no errors.
INFO (type_text): The function returns information about the current operating environment (Microsoft Excel).
ISBLANK (value): The function returns the boolean value, returns TRUE if the value is blank (empty), otherwise returns the FALSE value.
ISERR (value): The function checks the value of an error and returns TRUE if there is an error.
ISERROR (value): The function checks to see if the value is an error and returns TRUE if there is an error, FALSE otherwise.
ISEVEN (number): The function to check the number is an even number. Returns TRUE if an even number and FALSE if an odd number.
ISLOGICAL (value): The function checks whether the value is a logical value or not.
ISNA (value): The function checks the value of the # N / A error or not, if the value is a # N / A error then returns the TRUE value, otherwise returns the FALSE value.
ISNONTEXT (value): The function returns the value TRUE or FALSE, checking if the value is a value different from Text.
ISNUMBER (value): The function to test the value is a numeric value, if it is a number, then return TRUE if not FALSE.
ISODD (number): The function that tests the number is an odd number or not, the function returns TRUE if it is an odd number.
ISREF (value): The function checks whether a value is a reference (cell address or range) and returns TRUE if the value is a reference.
ISTEXT (value): The function checks whether the value is a Text type or not, the function returns TRUE if the value is a Text value.
N (value): The function returns a value converted to number (convert value to number).
NA (): The function returns the # N / A error value to prevent unforeseen problems before creating the function.
TYPE (value): The function returns a number indicating the data type of value.
So you know the function of each function in the information function group in Excel. When you know the function of the function, you will be able to choose the function to use to suit the needs. Good luck!
You should read it
- Summary of Excel exercises from basic to advanced
- Summary of technical functions in Excel
- How to use functions to identify and calculate date information in Excel
- How to fix the SUM function doesn't add up in Excel
- Complete financial functions in Excel you should know
- MS Excel - Lesson 5: Excel formulas and functions
- Common math functions in Excel
- Comparison functions in Excel - How to use comparison functions and examples using comparison functions
May be interested
- Common math functions in Excelsummary of common calculation functions in excel for accountants.
- Comparison functions in Excel - How to use comparison functions and examples using comparison functionscomparison functions in excel - how to use comparison functions and examples using comparison functions with a large amount of data, you want to check for duplicates by checking normally, it is really hard. in this article, introduce to you the functions
- Date time functions in Excelexcel supports you to process and calculate quickly with the functions that excel provides such as calculation functions, date functions ... one of them is the function of time to help you handle the prices. time value: hour, minute, second conveniently
- 10 EXCEL functions that ACCOUNTERS often usein excel, there are many functions that can help accounting in daily data entry, but here are some common functions used by accounting.
- The 10 most useful but often forgotten functions in excelmicrosoft excel is an extremely effective and effective calculation tool not only for accounting and office but also for many other industries.
- Logical functions (logical) in Excellogical functions are used a lot during data processing in excel. the article summarizes the syntax and functions of functions in logical function groups in excel.
- How to use Excel's VALUE functionexcel's value function will convert a string to a digital form, which can be combined with other functions such as left function, right function, mid function.
- Instructions for using Index function in Excelindex is a function that returns an array in excel. when using the index function, you get the values in a cell between the column and the row.
- Tips for working with functions in Excelfunctions that work with excel functions functions are predefined formulas for performing specific calculations, or for manipulating spreadsheets.
- How to add computers to Excelto perform complex calculations on excel or even change units, we can install computers on excel.