Skip to main content

Problem with Unavailable Formulas in Excel

The problem

Certain formulas (see the table below) cannot be accessed in Excel. They either show up as “N/A” or simply aren’t listed as an option.

Solution

The missing formulas are only available through Office 365 licensing and not through the default Microsoft Office Professional Plus 2019 licensing. You’ll need to reinstall and activate the Office 365 version of Excel in order to access them.