Forum Discussion

Brass Contributor

Jun 25, 2025

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:

wiens
Jun 30, 2025
This bug has been resolved. I have done a clean installation of Windows and Office.

MVP

Jun 26, 2025

To pay safe, try this since VBA evaluates ^ before unary minus unless parentheses are used properly

a = (-y) ^ 2

Brass Contributor

Jun 26, 2025

I have tried your method, but the answer is still not correct. I use in Office 365 VBA version 7.1 build 1146.