INFO function - The function returns the current operating environment information in Excel
The following article introduces you to the INFO function - one of the functions in the group of information functions that is very popular in Excel.
Description: The function returns the current operating environment information.
Syntax: INFO (type_text)
Inside:
- type_text: The value specifies the type of information to return, is a required parameter. Including the information:
+ type_text = 'DIRECTORY' -> function returns the path of the current directory.
+ type_text = 'NUMFILE' -> function returns the current number of sheets.
+ type_text = 'ORIGIN' -> function returns the absolute reference of the top and leftmost cell.
+ type_text = 'OSVERSION' -> function returns the current operating system version as a text.
+ type_text = 'RECALC' -> function returns the current calculation method.
+ type_text = 'RELEASE' -> function returns the version of Microsoft Excel as a text.
+ type_text = 'SYSTEM' -> function returns the name of the current operating environment.
For example:
Identify information about the operating environment described in the following data table:
- In the cell to calculate enter the formula : = INFO (C6)
- Press Enter -> return value is:
- Similarly copying the formula for the remaining values results:
Above are instructions and some specific examples when using the INFO function in Excel.
Good luck!
You should read it
- TODAY function - The function returns the current date value in the format in Excel
- How to use the IF function in Excel
- How to use the IFS function in Excel 2016
- CHISQ.TEST function - The function returns the independence test in Excel
- OR function in Excel, how to use the OR function, and examples
- How to use Hlookup function on Excel
- GAMMA function - The function returns the gamma function value in Excel
- POISSON.DIST function - The function returns the Poisson distribution in Excel
May be interested
- QUARTILE.EXC function - The function returns the quartile of a dataset without values 0 and 1 in Excelquartile.exc function: the function returns the quartile of the data set, with percentile values from 0 to 1 excluding 0 and 1. the support function is from excel 2010 onwards. syntax: quartile.exc (array, quart)
- PHI function - The function returns the value of the density function for a normal distribution in Excelphi function: the function returns the value of the density function for a standard normal distribution. support functions from excel 2013 onwards. syntax: phi (x)
- BETA.DIST function - The function returns the Beta distribution in Excelbeta.dist function: the function returns the beta distribution to study the variability of a number of things through a sample. support functions from excel 2010 onwards. syntax: beta.dist (x, alpha, beta, cumulative, [a], [b])
- How to use the IFS function in Excel 2016the ifs function in excel is a logical function introduced in excel 2016. this function is a function that replaces the nested if function and is much easier to use. the ifs function checks one or more conditions and returns a value that meets the first true condition.
- FTEST function - The function returns the result of an F-Test in Excelthe following article details how to use ftest - the function returns the result of an f-test. in statistical probability, the determination of the correctness and the deviation between two data samples is a regular and extremely important job.
- GAMMA.INV function - The function returns the inverse of the gamma distribution in Excelgamma.inv: the function returns the inverse of the gamma distribution, using this function to study their distribution variables that may be symmetrical. support functions from excel 2010 onwards. syntax: gamma.inv (probability, alpha, beta)
- How to use ADDRESS function in Excelthe address function in excel takes the number of rows and column numbers as arguments and returns the reference of the standard cell (cell address). for example, if you go to row 4 and column 3, the function returns c4.
- CELL function - The function returns information about the format or content of a cell in Excelcell function: the function returns information about the format or content of a cell. syntax: cell (info_type, [reference])
- FISHER function - The function returns the Fissher transformation at x in Excelfisher function: the function returns the fissher transformation at x. this transformation creates a normal distribution function, using this function to test a hypothesis based on a correlation coefficient. syntax: fisher (x)
- QUARTILE function - The function returns the quartile of a dataset in Excelthe quartile is an indispensable value in the field of surveying and sales, it helps you evaluate certain criteria in a set. the following article details how to use quartile function, the function returns the quartile of a dataset.