Can you post the result using xl2bb
xl2bb is an excel addin available in the right hand side of reply box. Download and unzipp it and run. Then you will get an Mr Excel Addin.
Lets try why office 2016 is resulting in error.
Have you tried to confirm the formula with Ctrl+shift+Enter