To supply an angle to TAN in degrees, multiply the angle by PI()180 or use the RADIANS function to convert to radians.

In geometric terms, the tangent of an angle returns the ratio of a right-triangles opposite side over its adjacent side.

For example, the the tangent of PI()4 (45) returns the ratio of 1.0.

For example, to get the TAN of 60 degrees, you can use either formula below.

The function has two vertical asymptotes within the range 0, 2 where the output diverges to infinity.

The tangent function can be equivalently defined in terms of SIN and COS.

To supply an angle to COS in degrees, use the RADIANS function to convert to radians.

We create short videos, and clear examples of formulas, functions, pivot tables, conditional formatting, and charts.

I can append it to a number in an individual cell using Alt-00B0, but have not been able to make that work in the custom number format setup, so I can use it in a group of cells.

Use ALT 0176 to add the degree symbol to the end (ex.

Click OK. Note You must use the numeric keypad to type the numbers and not the keyboard.

Make sure that the NUM LOCK key is on if your keyboard requires it to type numbers on the numeric keypad.

This will add a degree symbol to the end of all numbers currently in those cells and any future ones added.

Here is an article that may provide additional ideas: I found this utility that would add new number formatting functionality in Excel including adding a degree symbol: ConnectCode I hope this helps.

Alt-0176 in the ASCII (decimal) section is where I should have looked, but didnt think of checking that.

That way, people with a similar situation in the future will be able to quickly see what ultimately helped.

Also please exercise your best judgment when posting in the forums--revealing personal information such as your e-mail address, telephone number, and address is not recommended.

If youre new to the TechRepublic Forums, please read our TechRepublic Forums FAQ.

How Do You Put Degrees In Excel For Mac