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. :>(
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Using COS in VBA, incorrect value returned 5
VBA macro Trignometry function 2
Save last item copied 0
Power Pivot with 2 sets of values 0
Cosine of 90 degrees 6
Why Cos(45) is not equal 1/Sqrt(2)? 2
Delta E(cmc) formula 10
Using Degrees in trigonometric functions 1

Top