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.