Can you use degrees in excel

In this next example, we wish to know the launch angle, a , of the water ski ramp pictured above. To find a , we can use the Law of Sines which, in this case can be written We can rewrite this equation as. Using the arcsine inverse sine we can find the angle a using the equation The screen shot below shows how we used Excel to determine that the launch angle of the ramp is In our final trigonometry example, we will use Excel to examine the trig identity Notice in the screen shot below that this identity holds true when q is given in radians and degrees.

Note the units for the angle q are placed in different cells than the numbers. If we place the numbers and the units in the same cell, Excel will not be able to decipher the number and therefore we will not be able to reference the cells for use in any equation! See the complete list of Excel's built-in mathematical and trigonometric functions and their descriptions.

If you have a question or comment, send an e-mail to. Displaying Symbols E 7. Now you can use this symbol as any other character in excel. If you often need to add the degree symbol to numbers in a range, you can use a simple VBA code to do this quickly.

This can be helpful when you get this data from a database or from other people and you have to add the degree symbol to all these numbers. The above code goes through all the cells in the selection and adds a degree symbol at the end of the number in the cell. You need to put this code in any module in the VB Editor. Once inserted, you can run the code from the VB Editor, add a button as I did in the above example , or even add this to the Quick Access Toolbar. So these are the five methods plus the bonus VBA method you can use to type the degree symbol in Excel.

Best Excel Shortcuts. The function's output will always be in the range [-1, 1]. The Excel COS function returns the cosine of an angle given in radians. The Excel TAN function returns the tangent of angle given in radians.

Skip to main content. Excel SIN Function. Get the sine of an angle provided in radians. Return value.