Forum Discussion
Solved
Wrong VBA calculation answer
I am getting for a answer -1. It should be +1. This is calculation error in VBA. I use this version of VBA:
This bug has been resolved. I have done a clean installation of Windows and Office.
To pay safe, try this since VBA evaluates ^ before unary minus unless parentheses are used properly
a = (-y) ^ 2
I have tried your method, but the answer is still not correct. I use in Office 365 VBA version 7.1 build 1146.
This bug has been resolved. I have done a clean installation of Windows and Office.
This problem has been solved in build Windows 11 Insider Preview 27898.1000: "Fixed an underlying issue in the previous flight, which could lead to Math.Pow() not outputting the correct result, which could lead to unexpected behavior in apps and games."