complex engineering formula in Excel

Q82. In Excel, how can I calculate values applying complex Engineering formulas using Excel?

For example, I need to calculate x using the formula shown below given hd and aroof.

excel complex engineering formula

To do it in Excel, here is the answer:

a) Break down the formula and work from inside. First determine Tan aroof. To know the function name to be used to calculate this parameter, click on "Math & Trig" under "Formulas" since Tan is a Trigonometry function.

Scroll through the list and select appropriate function as shown below.

Note: The ribbon lists all the categories of functions supported by Excel. Navigating through those lists, select the function of interest as appropriate under general circumstances.

excel excel complex engineering formula

b) The "Function Arguments" dialog pops up. In the comments for the function it is clearly mentioned that the angle input for this function should be in radians.

excel excel excel complex engineering formula

c) To convert Degrees to radians, multiply the value by "PI()/180". Alternatively use formula "Radians(M3)" instead of M3*PI()/180.

excel excel excel excel complex engineering formula

d) Tan value is now returned by formula.

excel excel excel excel excel complex engineering formula

e) To get x value, enter the complete formula in a cell as shown below utilizing the Tan aroof value calculated previously.

excel excel excel excel excel excel complex engineering formula


You can find similar Excel Questions and Answer hereunder

1) How can I add a Footer to my printout with automatic page numbering?

2) How do i apply a formula to an entire column in Excel

3) How can I identify the cells that are dependent on a particular cell?

4) How can I find time interval between 2 times?

5) I have a cell with nested formulas that returns an error. In Excel, how can I step through the formulas to help with debugging?

6) Formula does not calculate in Excel

7) Given a raw data Table, how can I find the value of a field for a specific value of another field?

8) Applying a countif formula only to visible cells in a filtered list in Excel

9) I have to determine bonus for my staff based on ratings (for each rating, specific bonus amount). In Excel, how can I set up my Bonus Table?

10) How can I enter a picture in a cell?

11) How can I dynamically add series to an existing chart using VBA?

12) Can I apply formatting to a number concatenated with a Text?

13) How can I hide Formula Bar and Headings using VBA?

14) Sumifs with date range as criteria in Excel

15) How do I enter a formula in a cell using VBA (using Absolute Reference)?