Microsoft Excel Formulas: My formula is showing a different result than expected from a calculator

Danial Rizal 0 Reputation points
2025-03-11T05:24:05.13+00:00

I'm making an excel spreadsheet calculating voltage values of a single phase rectifier system. However, the formula is outputting different values than expected.

User's image

The above formula outputs

User's image

However, the actual calculated value is

94V

The intended formula is as following:

User's image

Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,801 questions
0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  1. Viorel 120.4K Reputation points
    2025-03-11T05:43:14.7533333+00:00

    Try to use (2*PI()) instead of 2*PI().

    0 comments No comments

  2. 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()))

    User's image


    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.

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.