Formula for a 360 dregree cycle

[Captain Randy]

, I want to take 0001° to 360° and make a sin wave from these numbers.
0° would be the bottom start of cycle,curve up to 180° then at 181° start down to 000° then at 001° start working back up to 180.

This way I would have a cycle based on the degree angles.
I have worked with Radians and Degrees in Excel but when it gets to 360 and the next number number is 001 it drops like a rock. When displayed in a chart form.

Is there a formula that can be used to do this?

Thank You in advance.

 

[Ruddles]

If your degrees are in column A, place the following in B1 and copy down:-

=180-ABS(180-A1)

This will convert column A which is cycling from 0 to 360 into a series of numbers which cycle from 0 to 180 and back to 0.

 

[mikerickson]

(0,0) to (180,180) to (360,0)

If degrees are in column A, try

=90-90*COS(RADIANS(A2))

 

[Captain Randy]

Thank You very much that is what I was wanting to do..." Thank You"

 

[Captain Randy]

Thank You, "Mikerickson and Rubbles" very much that is what I was wanting to do...

"Thank You"