SIN(90)

[Eric]

If I use a calculator to compute sin 90¢X, the answer should be 1.
When I enter the formula =SIN(90) in Excel, the anwser is 0.894.
How can I get the answer of sin 90¢X in Excel?
Thanks in advance~~

 

[Bob Phillips]

It works on radians so you have to convert

=SIN(RADIANS(90))

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Eric]

Thank you very much!!

It works on radians so you have to convert

=SIN(RADIANS(90))

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my
addy)

 

[Tyro]

A quick check of Excel help reveals:

SIN function
Returns the sine of the given angle.
Syntax
SIN(number)
Number is the angle in radians for which you want the sine.

Tyro

 

[Bob Phillips]

You mean like I told 5 and a quarter hours ago?

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Paul Hyett]

A quick check of Excel help reveals:

SIN function
Returns the sine of the given angle.
Syntax
SIN(number)
Number is the angle in radians for which you want the sine.

Who uses radians rather than degrees, anyway?

 

[Bob Phillips]

Microsoft <g>

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Bruce Sinclair]

Who uses radians rather than degrees, anyway?

Radian is the SI standard. Degrees/minutes/seconds are 'outside the SI' and
I haven't seen 'grads' used for a while.
Units are everything ... so assume them at your peril. ... and do read the
help - sometimes it helps.

 

[poliskrini]

Radian is the SI standard. Degrees/minutes/seconds are 'outside the SI' and
I haven't seen 'grads' used for a while.
Units are everything ... so assume them at your peril. ... and do read the
help - sometimes it helps.

can i ask you something? how can i convert radians into grads???

 

[Dave Peterson]

There are 2*Pi radians in a circle.
There are 400 Grads in a circle.
There are 360 degrees in a circle.

so if A1 contains radians, then
=400*a1/(2*pi())
will return the number of grads.

 

[Gord Dibben]

1 radian = 63.66198 grads

1 grad = 0.01570796 radians.

You do the math.


Gord Dibben MS Excel MVP

 

[Harlan Grove]

Who uses radians rather than degrees, anyway?

Bricklin and Frankston did in VisiCalc, and that set the base standard
for all spreadsheets since.

Backwards compatibility is a wonderful thing, ain't it?

 

[Nick]

Who uses radians rather than degrees, anyway?

A mathematician would use radians as it is the natural unit to use for
differentiation, power series etc.

Who apart from a mathematician would use SIN?

 

[Dave Peterson]

Maybe biblical scholars.

Let he who is without SIN cast the first stone.

I guess no one threw any stones, so everyone had some SIN.

(But I may be wrong...)

 

[Rick Rothstein \(MVP - VB\)]

Not really... if "he" is **without** "SIN", then it doesn't matter if SIN
uses radians or not.<g>

Rick

 

[Bob Phillips]

peccavi - General Charles Napier

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Sandy Mann]

The things that you learn in these Newsgroups! <g>

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk

peccavi - General Charles Napier

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my
addy)

 

[Bruce Sinclair]

can i ask you something? how can i convert radians into grads???

I can do better than that ... here is a GREAT site that can convert anything
to anything :

Convertit.com

If there's something it can't convert, I haven't found it yet. I tested it
on the 'methuselah' (sp ?) ... no problems.

Enjoy.