Excel Made Easy

Complex engineering formula in Excel

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

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.

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.

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

d) Tan value is now returned by formula.

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

You can find similar Excel Questions and Answer hereunder

1) How do I copy a Table from one location to another and retain all formulas, formats and columnwidths?

2) Formula converts date to quarter and year in Excel

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

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

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

6) Formula does not calculate in Excel

7) I have a complex WorkSheet with lot of fields and data - How can I quickly find the cells that have formulas?

8) How do I enter a formula in a cell using VBA (using Relative Reference)?

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

10) One of my formulas has returned an error - how can I trace the error to fix it?