Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 229
Default 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


  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default 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



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
maths expression antilog10 andy Excel Discussion (Misc queries) 7 December 13th 05 09:43 PM
Maths Fonts Sue Excel Discussion (Misc queries) 4 October 31st 05 01:56 AM
Maths Fonts Sue Excel Discussion (Misc queries) 2 October 25th 05 11:39 AM
How do I define and solve a maths equation using excel? excel nub New Users to Excel 1 October 9th 05 11:04 AM
result is Zero on every maths functions - sum, multiplication ... etc F. Excel Worksheet Functions 1 January 30th 05 02:05 PM


All times are GMT +1. The time now is 01:21 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright 2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"