17.3.Info | ||||
17.3.1. | INFO(type_text) returns information about the current environment | |||
17.3.2. | =INFO("numfile") return the number of active worksheets | |||
17.3.3. | =INFO("recalc") returns the recalculation mode for the workbook | |||
17.3.4. | =INFO("directory") returns the path of the current directory. | |||
17.3.5. | =INFO("origin") returns the address of the cell at the top and to the left of the scrollable area | |||
17.3.6. | =INFO("osversion") returns the name of the current operating system | |||
17.3.7. | =INFO("release") returns the version number of Excel being run | |||
17.3.8. | =INFO("system") returns the name of the operating environment: either mac or pcdos | |||
17.3.9. | Combine IF and INFO formula to check the Excel version |