Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cosine function
Hi
I'm working with a lot of math functions in the VB editor, but I can't find the function for the cos^2(X) example: ((Cos ^ 2)(Atn((t2 * Cos(a) - 10.5 * (10 ^ -3) * Sin(a) - x))) doesn't work - so how am I supposed to write it? Can anybody help me with this??? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cosine function
Have you looked in the help file for Cos?
-- Jim Cone Portland, Oregon USA "mjoens" wrote in message Hi I'm working with a lot of math functions in the VB editor, but I can't find the function for the cos^2(X) example: ((Cos ^ 2)(Atn((t2 * Cos(a) - 10.5 * (10 ^ -3) * Sin(a) - x))) doesn't work - so how am I supposed to write it? Can anybody help me with this??? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cosine function
Instead of writing
cos^2(X) you have to write (cos(X))^2 Success!!! -- met vriendelijke groetjes "mjoens" schreef in bericht ... Hi I'm working with a lot of math functions in the VB editor, but I can't find the function for the cos^2(X) example: ((Cos ^ 2)(Atn((t2 * Cos(a) - 10.5 * (10 ^ -3) * Sin(a) - x))) doesn't work - so how am I supposed to write it? Can anybody help me with this??? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cosine function
When you see Cos²(X), that is notational convenience... it helps clarify
that X is not being squared which could be mistaken if you wrote it as Cos(X)², but mathematically, what it really means is take the Cos(X) and raise it to the second power, like this... (Cos(X))^2 -- Rick (MVP - Excel) "mjoens" wrote in message ... Hi I'm working with a lot of math functions in the VB editor, but I can't find the function for the cos^2(X) example: ((Cos ^ 2)(Atn((t2 * Cos(a) - 10.5 * (10 ^ -3) * Sin(a) - x))) doesn't work - so how am I supposed to write it? Can anybody help me with this??? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cosine Function Returns Wrong Answer! | Excel Discussion (Misc queries) | |||
Cosine of 90 degrees | Excel Worksheet Functions | |||
User Function Question: Collect Condition in Dialog Box - But How toInsert into Function Equation? | Excel Programming | |||
how cani multiply cosine of an angle with a number,Ex cos60*2 | New Users to Excel | |||
Include exponential (and exp-cosine-sine) integral maths functions | Excel Worksheet Functions |