TAN Excel Formula

Author Zaheer    Category Formulas     Tags ,

Microsoft Excel is a spreadsheet that is capable of creating files for workbook data containing three worksheets by default. Sheet is a shortened name for a worksheet or spreadsheet in Excel workbook. Worksheet is a grid or table composed of columns and rows making it convenient to organize, consolidate, calculate and enter data. Even though, Lotus 123 and VisiCalc introduced spreadsheet concepts on many personal computers. Microsoft Excel provides graphical interface to multiple sheets of link and layer using mouse in the windowed environment.

By creating worksheets, you can set series of worksheets that workbook can generate through default. Thus, it can be navigated through menu options, tools and general. In entering the data in a worksheet, you have to click the cell you wish to enter the data then start typing. Thus, it allows the users to enter numbers, texts, images and formulas into cells. The examples of the various formats are justification, font, color and size, which are applicable to cell worksheet data.

The major benefits of Excel worksheet is that, it allows the user to import, create, report and analyze on various large amounts of given data accurately and quickly. Excel 2007 supports individual worksheets over one million rows with 16,000 columns that features an array of statistical, financial, arithmetic and engineering functions. It also supports graphics and charts enabling the communication, analysis and collaboration of sets of diverse data. One of the Excel functions that benefit the users is the TAN function. A TAN function is included in the groups of trigonometric functions formulated in relation with degrees and radians.

TAN function, in Excel returns the tangent of the given angle. The syntax for TAN functions is “TAN(number)”. The number argument is considered the angle in radians that the user wants to get the tangent of.

REMARK:

Through multiplying the argument by PI()/180, you can get the conversion of the argument to radians if it is in degrees. The user can also use the RADIANS function.

Inserting the Tangents in Microsoft Excel:

Tangent in Excel is the trigonometric function calculating the connection between angles and sides of the right triangle. Since Excel uses radians in its calculations, the user must combine RADIANS function with the Excel’s TAN function. This is when you would like to place degrees with your worksheet’s calculation. The RADIANS function alters the radians into degrees using the formula of this function representing the angles as an angle in its degrees.

Instructions for Insertion:

  • Click the cell A1 inside the Excel worksheet. Type given radian angle you like to calculate the tangent then press the enter key.
  • Click the cell A2. Type in the formula of the TAN function and don’t forget to include an equal (=) sign. Include cell containing the radian angle within the “number” portion of TAN function. Press the Enter key.
  • Click the cell A3. Type the angle measured in degrees in which you want to calculate for the tangent of.
  • Click the cell A4. Type again the TAN function with the equal (=) sign. Include radian function as the TAN function “number” portion. Include cell containing the degree angle as “angle” of RADIANS function portion. Press the Enter key after you have finished typing. Excel alters the angle within the cell A3 into radians. Excel takes back one in A4 cell. This is now your given answer.

Post comment