Try to use (2*PI())
instead of 2*PI()
.
Microsoft Excel Formulas: My formula is showing a different result than expected from a calculator
Danial Rizal
0
Reputation points
I'm making an excel spreadsheet calculating voltage values of a single phase rectifier system. However, the formula is outputting different values than expected.
The above formula outputs
However, the actual calculated value is
94V
The intended formula is as following:
2 answers
Sort by: Most helpful
-
Viorel 120.4K Reputation points
2025-03-11T05:43:14.7533333+00:00 -
Emi Zhang-MSFT 28,746 Reputation points Microsoft External Staff
2025-03-11T07:20:55.9866667+00:00 Hi,
Try this formula:
=(132.94/SQRT(2))*SQRT(1-(3/180))+(SIN(3*2)/(2*PI()))
If the response is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.