the angle format (º ‘ ‘’) and calculation?

macropod · #1 04-23-2012, 04:19 PM

Hi Jamal,

For Sin(Ø) and Cos(Ø) you can use:
=SIN(RADIANS(C3)) and =COS(RADIANS(C3))
or:
=SIN(RADIANS(B3*24)) and =COS(RADIANS(B3*24))
in row 3 and copy down. This is more accurate than using your 3.14/180 conversion. For radians, you can use =RADIANS(C3) or =RADIANS(B3*24)

I'm not sure what you mean by:

Quote:

I’m striving to proceed in calculations.

In decimal terms, your angles add up to 540.0002778 degrees.

Jamal NUMAN · #2 04-24-2012, 12:49 PM

Quote:

Originally Posted by macropod

Hi Jamal,

For Sin(Ø) and Cos(Ø) you can use:
=SIN(RADIANS(C3)) and =COS(RADIANS(C3))
or:
=SIN(RADIANS(B3*24)) and =COS(RADIANS(B3*24))
in row 3 and copy down. This is more accurate than using your 3.14/180 conversion. For radians, you can use =RADIANS(C3) or =RADIANS(B3*24)

I'm not sure what you mean by:

In decimal terms, your angles add up to 540.0002778 degrees.

Many thanks Paul for the very crucial enhancement. It is much more powerful now.

I’m not sure if there is a way to remove the little minus sign (-) shown under the degree sign (º). Please, have a look on the attached screenshot.

I’m striving (motivated) to commence the entire angles calculation after your great help.

Best

Jamal

Jamal NUMAN · #3 04-24-2012, 02:06 PM

Quote:

Originally Posted by macropod

Hi Jamal,

For Sin(Ø) and Cos(Ø) you can use:
=SIN(RADIANS(C3)) and =COS(RADIANS(C3))
or:
=SIN(RADIANS(B3*24)) and =COS(RADIANS(B3*24))
in row 3 and copy down. This is more accurate than using your 3.14/180 conversion. For radians, you can use =RADIANS(C3) or =RADIANS(B3*24)

I'm not sure what you mean by:

In decimal terms, your angles add up to 540.0002778 degrees.

I’m again in trouble Paul.

I couldn’t know how to proceed with the “if statement” below:

If (B3>180º, B3-180º, B3+180º)

How the 180º in the “if statement” can be understood as angle in degrees?

The file and screenshot are attached

Best

Jamal

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Date Calculation	Lights	Excel	5	04-18-2012 04:31 AM
calculation of start date	ketanco	Project	1	02-29-2012 07:01 AM
Formula calculation	danbl	Excel	8	02-23-2012 04:35 AM
Calculation within Cells	manich1	Excel	2	12-07-2011 02:59 PM
Angle Bracket Problem, STYLEREF in Header of a Protected Document	wordjunkie	Word	0	06-18-2010 04:34 AM