Shows information about the memory details such as total memory, free memory, … . This function is available via the ‘Memory’ taskpane as well as directly via the cell “=MEMORY(…)”

Return Value

The returned value depends on the chosen memory query, see below.


query – Specifies the specific memory data to be obtained, following queries are available:

  • TOTAL_MEMORY – Total memory in gigabytes.
  • AVAILABLE_MEMORY – Available memory in gigabytes.
  • PERCENT_MEMORY_IN_USE – Memory usage in percent.


Excel showing free and used memory using the MEMORY formula

Instructional Video