The "#NAME?" value indicates that function is not recognized by Excel. For instance:
The output above indicates that the NumXL the license key is either missing or expired.
Check your NumXL installation and/or the license key by selecting INFO and then About NumXL. In the pop up your NumXL license key should be present if not, please activate your license key.