COS()

P

PierreL

I am really confused!
COS(45/(2*PI()) returns .63
should be .707
What do I type wrong?
Thanks.
Pierre
 
D

Dana DeLouis

I believe you forgot to include 360. Here's two ideas:

=COS(45*PI()/180)
or
=COS(RADIANS(45))

Both return .707...which is the same as =1/SQRT(2)

HTH
 
P

PierreL

Thanks Dana,
Boy was I tired!
Pierre

Dana DeLouis said:
I believe you forgot to include 360. Here's two ideas:

=COS(45*PI()/180)
or
=COS(RADIANS(45))

Both return .707...which is the same as =1/SQRT(2)

HTH
Click to expand...
 
D

Dana DeLouis

Please excuse the above message. Outlook locked up and sent that message
despite my attempts to prevent it from doing so. I even tried the menu
item:
Message | Cancel Message, and it would not work.

What I was going to say is that one other technique is to insert a range
name called "Deg" and set it equal to =PI()/180.

Then you can use something like this...
=COS(45*Deg)

Again, not necessary. Just a different technique to simulate working with
units.
Sorry about the post. :>(
 
Top