Sunday, December 23, 2012

How to Use Excel's TAN Function


1. Enter your input values into a row or column in a blank spreadsheet. The 'input value' refers to the angle, represented by the 'x.' Let's assume you enter an input value of 5 and you enter it in cell A1.
2. Click your cursor in a different cell and type the formula '=Tan(A1).' This gives you the result of -0.14255. This number represents the tangent of your angle.
3. Change the number of decimal points in your answer if necessary. Go to 'Format' and 'Cells.' Select the 'Number' tab, then 'Number' and enter the number of decimal points you would like.
4. Compare your answers with the most popular tan values: 'Tan(0 degrees) = 0.0000;' 'Tan(30 degrees) = 0.5773;' 'Tan(45 degrees) =1.000;' 'Tan(60 degrees) = 1.7320;' 'Tan(90 degrees) = infinity.'

Blogger news