Currently, it is not possible to pass a formula to the Office API and receive an evaluation of it. There are workarounds, like writing to an empty cell, or writing to a scoped name. Both solutions a...
100%! ry_mac_202 adds some important points!
Would be great to get some further attention from the Microsoft product team!