Maths In Excel - Help Needed!

[Keir FM]

Here is what Im trying to do:

Use the above equations (Sinh,Cosh,Tan) to create a 4-column table labelled
x, sinh(x), cosh(x) and tanh(x) and calculate the values of each function for
40 points (i.e. a step value of ï°/20 or 0.157) along x between 0 and 2ï°
radians.

Im not overly clued up on excel, so any help would be much appreciated -
Also, if anyone really enjoys doing things like the above - Id be happy to
send them a paper to do for me!

Thanks for you time
Keir

 

[iliace]

Enter your headers in columns A, B, C, D - first row.

In A2, type 0 and press Enter.
In A3, type =A2+(PI()/20) and press Enter
Copy A3 (Ctrl+C), select cells A4:A41 and Paste (Ctrl+V)
In cell B2, type in =SINH($A2) and press Enter
In cell C2, type in =COSH($A2) and press Enter
In cell D2, type in =TANH($A2) and press Enter
Select cells B22 and press Copy (Ctrl+C)
Select cells B341 and press Paste (Ctrl+V)

Hope that helps.

 

[Keir FM]

thanks so much! really appreciate it!

Enter your headers in columns A, B, C, D - first row.

In A2, type 0 and press Enter.
In A3, type =A2+(PI()/20) and press Enter
Copy A3 (Ctrl+C), select cells A4:A41 and Paste (Ctrl+V)
In cell B2, type in =SINH($A2) and press Enter
In cell C2, type in =COSH($A2) and press Enter
In cell D2, type in =TANH($A2) and press Enter
Select cells B22 and press Copy (Ctrl+C)
Select cells B341 and press Paste (Ctrl+V)

Hope that helps.