|
Maths In Excel - Help Needed!
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 |
Maths In Excel - Help Needed!
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 |
Maths In Excel - Help Needed!
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 |
| All times are GMT +1. The time now is 02:10 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com