Well, in this statement
Excel custom functions are available on the following platforms.
Office on Windows
Microsoft 365 subscription
retail perpetual Office 2016 and later
something should be wrong:
including the consequences, aka the #NAME error in custom functions.