If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
TAN different to a calculator? Please help would be appreciated lo
Hi,
I am doing my GCSE at the moment and I have come up with a fomula to calculate the area of any polygon. My formula includes TAN but when I use the TAN function on Excel it gives me a completely different answer to my calculator. Please help, is TAN different in America? Sorry if this sounds really stupid but I need to know. Thanks |
#2
|
|||
|
|||
TAN different to a calculator? Please help would be appreciated lo
Be careful when using trig functions, you gotta make sure you're using
radians/degrees correctly. The TAN() in excel handles Radians. For example to get the tangent of 45 DEGREES use the following formula: =TAN(45*PI()/180) -- Regards, Dave "!!HELP!!" wrote: Hi, I am doing my GCSE at the moment and I have come up with a fomula to calculate the area of any polygon. My formula includes TAN but when I use the TAN function on Excel it gives me a completely different answer to my calculator. Please help, is TAN different in America? Sorry if this sounds really stupid but I need to know. Thanks |
#3
|
|||
|
|||
TAN different to a calculator? Please help would be appreciated lo
Do you know the difference between degrees and radians? I suspect you
are using degrees but you need radians in the TAN( ) formula - Help will explain how to convert. Pete |
#4
|
|||
|
|||
TAN different to a calculator? Please help would be appreciated lo
David's answer is correct but to save you remembering is it PI()/180 or
180/Pi() use the RADIANS and DEGREES function. A1 has 45 entered (meaning 45 degrees), to get the tan of this angle use =TAN(RADIANS(A1)) B1 has 0.866 and you what the asin (inverse sine), use =DEGREES(ASIN(B1)) best wishes with GCSE - I took mine 50 years ago when it was called 'O' level -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "!!HELP!!" wrote in message ... Hi, I am doing my GCSE at the moment and I have come up with a fomula to calculate the area of any polygon. My formula includes TAN but when I use the TAN function on Excel it gives me a completely different answer to my calculator. Please help, is TAN different in America? Sorry if this sounds really stupid but I need to know. Thanks |
#5
|
|||
|
|||
TAN different to a calculator? Please help would be appreciate
Thanks people!!
That really helped me, the website just made it sound sooo complicated. I fully understand it and thank you greatly for your assistance! "Bernard Liengme" wrote: David's answer is correct but to save you remembering is it PI()/180 or 180/Pi() use the RADIANS and DEGREES function. A1 has 45 entered (meaning 45 degrees), to get the tan of this angle use =TAN(RADIANS(A1)) B1 has 0.866 and you what the asin (inverse sine), use =DEGREES(ASIN(B1)) best wishes with GCSE - I took mine 50 years ago when it was called 'O' level -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "!!HELP!!" wrote in message ... Hi, I am doing my GCSE at the moment and I have come up with a fomula to calculate the area of any polygon. My formula includes TAN but when I use the TAN function on Excel it gives me a completely different answer to my calculator. Please help, is TAN different in America? Sorry if this sounds really stupid but I need to know. Thanks |
#6
|
|||
|
|||
TAN different to a calculator? Please help would be appreciated lo
What units (degrees, radians, gradians) is your calculator set to? My US version of Excel requires the argument to the TAN function to be in radians, and I would assume that would be the same for versions for other countries. If your argument is in degrees, convert it to radians before applying the TAN function. -- MrShorty ------------------------------------------------------------------------ MrShorty's Profile: http://www.excelforum.com/member.php...o&userid=22181 View this thread: http://www.excelforum.com/showthread...hreadid=493910 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Moving to Outlook. Help appreciated. | Dave The Brain | Outlook Express | 5 | March 25th, 2005 10:21 AM |
Unable to open your default email folders - assistance appreciated | Senor Juences | General Discussion | 1 | February 12th, 2005 07:51 PM |
A template for a tent fold business card would be appreciated. | CPStRose | General Discussion | 1 | October 13th, 2004 11:32 PM |
any idea? any help would be greatly appreciated | Josh Henry | Running & Setting Up Queries | 2 | October 1st, 2004 05:38 PM |
Stubborn Link Data/Value Problem - Help Appreciated! | Jax | Links and Linking | 5 | January 8th, 2004 07:46 AM |