Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 B2:D2 and press Copy (Ctrl+C) Select cells B3:D41 and press Paste (Ctrl+V) Hope that helps. On Dec 5, 4:00 pm, Keir FM <Keir wrote: 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 |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
thanks so much! really appreciate it!
"iliace" wrote: 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 B2:D2 and press Copy (Ctrl+C) Select cells B3:D41 and press Paste (Ctrl+V) Hope that helps. On Dec 5, 4:00 pm, Keir FM <Keir wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
maths expression antilog10 | Excel Discussion (Misc queries) | |||
Maths Fonts | Excel Discussion (Misc queries) | |||
Maths Fonts | Excel Discussion (Misc queries) | |||
How do I define and solve a maths equation using excel? | New Users to Excel | |||
result is Zero on every maths functions - sum, multiplication ... etc | Excel Worksheet Functions |