PROVIDING ACCURATE, RELIABLE AND STRAIGHT TO THE POINT KNOWLEDGE ABOUT DIFFERENT IT TOOLS EXPLAINED WITH PRACTICAL EXAMPLES
CONTENTS
EXCEL FUNCTIONS-INFO
INTRODUCTION
INFO FUNCTION comes under the INFORMATION category in Excel.
The INFO functions provides the information about the operating system such as , current directory of the file in which we are working, number of worksheets in the current workbook, the visible first cell’s address, operating system’s version, current recalculation mode, release version of ms excel, system (mac or windows) etc.
This kind of information can be used if we need the system information for some process.
But there is always a safety warning issued with the use of this FUNCTION as it gives the information about the system which can be misused. so always be cautious while using this function.
PURPOSE OF INFO FUNCTION IN EXCEL
INFO FUNCTION RETURNS THE INFORMATION ABOUT THE CURRENT OPERATING ENVIRONMENT I.E. FEW LISTED INFORMATION ABOUT THE CURRENT SYSTEM OR OPERATING SYSTEM.
PREREQUISITES TO LEARN INFO
THERE ARE A FEW PREREQUISITES WHICH WILL ENABLE YOU TO UNDERSTAND THIS FUNCTION IN A BETTER WAY.
- Basic understanding of how to use a formula or function.
- Basic understanding of rows and columns in Excel.
- Of course, Excel software.
SYNTAX: INFO FUNCTION
The Syntax for the function is
=INFO(INFORMATION TYPE)
INFORMATION TYPE Type of information needed. Different types of information available are enlisted in next section.
INFORMATION TYPE AVAILABLE FOR INFO FUNCTION
FOLLOWING ARE THE CODES WHICH ARE RETURNED WHEN A CELL HAS ANY FORMAT FROM THE BUILT IN NUMBER FORMATS IN EXCEL.
“directory” Path of the current directory or folder.
position, as text prepended with “$A:”. This value is intended for for Lotus 1-2-3 release 3.x compatibility. The actual value returned depends on the current reference style setting. Using D9 as an example, the return value would
be:
- A1 reference style “$A:$D$9”.
- R1C1 reference style “$A:R9C4”
“osversion” Current operating system version, as text.
Macintosh = “mac”
Windows = “pcdos”
EXAMPLE:INFO FUNCTION IN EXCEL
DATA SAMPLE
We will try to use Cell function with different types of attributes. The INFO function will return the INFORMATION which is asked for.
Let us check the different attributes of H9 TO H15.
For the example,
steps to use INFO function (example)
EXAMPLE:INFO FUNCTION USAGE :ANIMATED STEPS
OTHER WAYS TO REACH THIS ARTICLE
WHAT IS EXCEL, HOW EXCEL WORKS, WRITE FORMULA IN EXCEL, EXAMPLE OF USING FORMULA IN EXCEL, ANIMATED EXAMLPE OF USING FORMULA IN EXCEL
YOU MAY LIKE
- HOW TO TROUBLESHOOT A FORMULA IN EXCEL?
- USE OF FONTS, FONT SIZE, INDENTATION, TEXT TO THE RIGHT, TEXT TO THE LEFT, TEXT IN THE MIDDLE ETC.
- how to insert table in excel?
- FOR MORE ARTICLES, CLICK EXCEL OR TYPE IN SEARCH BELOW.