Please note javascript is required for full website functionality.

Blog

A to Z of Excel Functions: the INFO Function

8 March 2021

Welcome back to our regular A to Z of Excel Functions blog.  Today we look at the INFO function.

 

The INFO function

The INFO function returns information about the current operating environment.  It employs the following syntax to operate:

INFO(type_text).


The INFO function has the following argument:

  • type_text: this is required and represents the specification of what type of information you want returned. 

It should be noted that:

  • in previous versions of Microsoft Excel, the "memavail", "memused" and "totmem" type_text values returned memory information.  These type_text values are no longer supported and now return an #N/A error value instead.

Please see my example below: 

We’ll continue our A to Z of Excel Functions soon.  Keep checking back – there’s a new blog post every business day.

A full page of the function articles can be found here

Newsletter