TAN function

PRO BASIC

The TAN function in Jspreadsheet Formulas Pro is used when you need to calculate the tangent of a specific angle. This angle should be inputted in radians. For example, if you use TAN with an argument of 1, it will return the tangent of 1 radian. This function can be very useful in trigonometry, geometry, and various fields of engineering and physics.

Documentation

Returns the tangent of an angle specified in radians.

Syntax

TAN(x)

Parameter	Description
`x`	The angle in radians for which you want the tangent. Jspreadsheet does not automatically convert degrees to radians, so if your angle is in degrees, you must first convert it using the RADIANS function.

Behavior

The TAN function calculates the tangent of a given angle. The angle should be provided in radians. Here's how it handles various types of inputs:

Numbers: The TAN function takes numerical values as input, which represent angles in radians. It returns the tangent of the given angle.
Text: If a text value is given as input, the function will return an error since it expects a numerical value.
Booleans: Boolean values are treated as numerical values where TRUE is equal to 1 and FALSE is equal to 0.
Empty cells: If an empty cell is given as input, the function will treat it as 0.
Errors: If the input cell contains an error, the TAN function will also return an error.

Common Errors

Error	Description
#VALUE!	This error is returned when the given input is non-numeric or the function is unable to find the tangent of the given angle.
#DIV/0!	This error is returned when the function tries to divide a number by zero. In context of the `TAN` function, it will generally occur if you are trying to find the tangent of an angle where the cosine is 0 (e.g., π/2 or 3π/2).

Best practices

Always ensure that the angle provided is in radians. If your angle is in degrees, you can convert it to radians using the RADIANS function.

Beware of angles that have cosine equal to zero as these will return a #DIV/0! error because tangent is not defined at these points.

Be aware that the TAN function expects numerical values. If non-numeric values are used, the function will return a #VALUE! error.

Always check for spelling errors in the function name to avoid the #NAME? error.

Usage

A few examples using the TAN function.

TAN(0)          // Returns 0, since tan(0) = 0
TAN(0.7854)     // Returns ~1, since tan(π/4 radians) = 1
TAN(1.0472)     // Returns ~1.732, since tan(60° in radians) = √3
TAN(RADIANS(45)) // Converts 45 degrees into radians, result = 1

Interactive Spreadsheet Demo

<html>
<script src="https://jspreadsheet.com/v11/jspreadsheet.js"></script>
<script src="https://jsuites.net/v5/jsuites.js"></script>
<link rel="stylesheet" href="https://jsuites.net/v5/jsuites.css" type="text/css" />
<link rel="stylesheet" href="https://jspreadsheet.com/v11/jspreadsheet.css" type="text/css" />

<link rel="stylesheet" href="https://fonts.googleapis.com/css?family=Material+Icons" />
<script src="https://cdn.jsdelivr.net/npm/@jspreadsheet/formula-pro/dist/index.min.js"></script>

<div id="spreadsheet"></div>

<script>
// Set your JSS license key (The following key only works for one day)
jspreadsheet.setLicense('ZjQ4ZmVjMzMwYzg0NTI4ODNkNTAxYTNiODk2NWExODliNzIzYjkyNGI3YWI0YTU3YzYzZTgyMGQ0Y2VhNWRlN2MzM2Q0YTkwOGEwYTY4NGY4YjU4Y2ViNjIwMzg0OGYwMGM1OWQ1YTZkOGI0M2M1NTc5MmFiZjVmMmM3MWFiODEsZXlKamJHbGxiblJKWkNJNklpSXNJbTVoYldVaU9pSktjM0J5WldGa2MyaGxaWFFpTENKa1lYUmxJam94TnpVNE56YzBNRFF5TENKa2IyMWhhVzRpT2xzaWFuTndjbVZoWkhOb1pXVjBMbU52YlNJc0ltTnZaR1Z6WVc1a1ltOTRMbWx2SWl3aWFuTm9aV3hzTG01bGRDSXNJbU56WWk1aGNIQWlMQ0p6ZEdGamEySnNhWFI2TG1sdklpd2lkMlZpWTI5dWRHRnBibVZ5TG1sdklpd2lkMlZpSWl3aWJHOWpZV3hvYjNOMElsMHNJbkJzWVc0aU9pSXpOQ0lzSW5OamIzQmxJanBiSW5ZM0lpd2lkamdpTENKMk9TSXNJbll4TUNJc0luWXhNU0lzSW1Ob1lYSjBjeUlzSW1admNtMXpJaXdpWm05eWJYVnNZU0lzSW5CaGNuTmxjaUlzSW5KbGJtUmxjaUlzSW1OdmJXMWxiblJ6SWl3aWFXMXdiM0owWlhJaUxDSmlZWElpTENKMllXeHBaR0YwYVc5dWN5SXNJbk5sWVhKamFDSXNJbkJ5YVc1MElpd2ljMmhsWlhSeklpd2lZMnhwWlc1MElpd2ljMlZ5ZG1WeUlpd2ljMmhoY0dWeklpd2labTl5YldGMElsMHNJbVJsYlc4aU9uUnlkV1Y5');

// Set the extensions
jspreadsheet.setExtensions({ formula });

// Create a new spreadsheet
jspreadsheet(document.getElementById('spreadsheet'), {
  worksheets: [{
    data: [
    [
        "Angle (radians)",
        "Tangent"
    ],
    [
        0,
        "=TAN(A2)"
    ],
    [
        0.7854,
        "=TAN(A3)"
    ],
    [
        1.0472,
        "=TAN(A4)"
    ],
    [
        -1.5708,
        "=TAN(A5)"
    ]
]
  }]
});
</script>
</html>

import React, { useRef } from "react";
import { Spreadsheet, Worksheet, jspreadsheet } from "@jspreadsheet/react";
import formula from "@jspreadsheet/formula-pro";
import "jsuites/dist/jsuites.css";
import "jspreadsheet/dist/jspreadsheet.css";

// Set license
jspreadsheet.setLicense('ZjQ4ZmVjMzMwYzg0NTI4ODNkNTAxYTNiODk2NWExODliNzIzYjkyNGI3YWI0YTU3YzYzZTgyMGQ0Y2VhNWRlN2MzM2Q0YTkwOGEwYTY4NGY4YjU4Y2ViNjIwMzg0OGYwMGM1OWQ1YTZkOGI0M2M1NTc5MmFiZjVmMmM3MWFiODEsZXlKamJHbGxiblJKWkNJNklpSXNJbTVoYldVaU9pSktjM0J5WldGa2MyaGxaWFFpTENKa1lYUmxJam94TnpVNE56YzBNRFF5TENKa2IyMWhhVzRpT2xzaWFuTndjbVZoWkhOb1pXVjBMbU52YlNJc0ltTnZaR1Z6WVc1a1ltOTRMbWx2SWl3aWFuTm9aV3hzTG01bGRDSXNJbU56WWk1aGNIQWlMQ0p6ZEdGamEySnNhWFI2TG1sdklpd2lkMlZpWTI5dWRHRnBibVZ5TG1sdklpd2lkMlZpSWl3aWJHOWpZV3hvYjNOMElsMHNJbkJzWVc0aU9pSXpOQ0lzSW5OamIzQmxJanBiSW5ZM0lpd2lkamdpTENKMk9TSXNJbll4TUNJc0luWXhNU0lzSW1Ob1lYSjBjeUlzSW1admNtMXpJaXdpWm05eWJYVnNZU0lzSW5CaGNuTmxjaUlzSW5KbGJtUmxjaUlzSW1OdmJXMWxiblJ6SWl3aWFXMXdiM0owWlhJaUxDSmlZWElpTENKMllXeHBaR0YwYVc5dWN5SXNJbk5sWVhKamFDSXNJbkJ5YVc1MElpd2ljMmhsWlhSeklpd2lZMnhwWlc1MElpd2ljMlZ5ZG1WeUlpd2ljMmhoY0dWeklpd2labTl5YldGMElsMHNJbVJsYlc4aU9uUnlkV1Y5');

// Set the extensions
jspreadsheet.setExtensions({ formula });

export default function App() {
    // Spreadsheet array of worksheets
    const spreadsheet = useRef();

    // Worksheet data
    const data = [
    [
        "Angle (radians)",
        "Tangent"
    ],
    [
        0,
        "=TAN(A2)"
    ],
    [
        0.7854,
        "=TAN(A3)"
    ],
    [
        1.0472,
        "=TAN(A4)"
    ],
    [
        -1.5708,
        "=TAN(A5)"
    ]
];

    // Render component
    return (
        <Spreadsheet ref={spreadsheet}>
            <Worksheet data={data} />
        </Spreadsheet>
    );
}

<template>
    <Spreadsheet ref="spreadsheet">
        <Worksheet :data="data" />
    </Spreadsheet>
</template>

<script>
import { Spreadsheet, Worksheet, jspreadsheet } from "@jspreadsheet/vue";
import "jsuites/dist/jsuites.css";
import "jspreadsheet/dist/jspreadsheet.css";
import formula from "@jspreadsheet/formula-pro";

// Set license
jspreadsheet.setLicense('ZjQ4ZmVjMzMwYzg0NTI4ODNkNTAxYTNiODk2NWExODliNzIzYjkyNGI3YWI0YTU3YzYzZTgyMGQ0Y2VhNWRlN2MzM2Q0YTkwOGEwYTY4NGY4YjU4Y2ViNjIwMzg0OGYwMGM1OWQ1YTZkOGI0M2M1NTc5MmFiZjVmMmM3MWFiODEsZXlKamJHbGxiblJKWkNJNklpSXNJbTVoYldVaU9pSktjM0J5WldGa2MyaGxaWFFpTENKa1lYUmxJam94TnpVNE56YzBNRFF5TENKa2IyMWhhVzRpT2xzaWFuTndjbVZoWkhOb1pXVjBMbU52YlNJc0ltTnZaR1Z6WVc1a1ltOTRMbWx2SWl3aWFuTm9aV3hzTG01bGRDSXNJbU56WWk1aGNIQWlMQ0p6ZEdGamEySnNhWFI2TG1sdklpd2lkMlZpWTI5dWRHRnBibVZ5TG1sdklpd2lkMlZpSWl3aWJHOWpZV3hvYjNOMElsMHNJbkJzWVc0aU9pSXpOQ0lzSW5OamIzQmxJanBiSW5ZM0lpd2lkamdpTENKMk9TSXNJbll4TUNJc0luWXhNU0lzSW1Ob1lYSjBjeUlzSW1admNtMXpJaXdpWm05eWJYVnNZU0lzSW5CaGNuTmxjaUlzSW5KbGJtUmxjaUlzSW1OdmJXMWxiblJ6SWl3aWFXMXdiM0owWlhJaUxDSmlZWElpTENKMllXeHBaR0YwYVc5dWN5SXNJbk5sWVhKamFDSXNJbkJ5YVc1MElpd2ljMmhsWlhSeklpd2lZMnhwWlc1MElpd2ljMlZ5ZG1WeUlpd2ljMmhoY0dWeklpd2labTl5YldGMElsMHNJbVJsYlc4aU9uUnlkV1Y5');

// Set the extensions
jspreadsheet.setExtensions({ formula });

export default {
    components: {
        Spreadsheet,
        Worksheet,
    },
    data() {
        // Worksheet data
        const data = [
    [
        "Angle (radians)",
        "Tangent"
    ],
    [
        0,
        "=TAN(A2)"
    ],
    [
        0.7854,
        "=TAN(A3)"
    ],
    [
        1.0472,
        "=TAN(A4)"
    ],
    [
        -1.5708,
        "=TAN(A5)"
    ]
]

        return {
            data
        };
    }
}
</script>

import { Component, ViewChild, ElementRef } from "@angular/core";
import jspreadsheet from "jspreadsheet";
import * as formula from "@jspreadsheet/formula-pro";

// Set your JSS license key (The following key only works for one day)
jspreadsheet.setLicense('ZjQ4ZmVjMzMwYzg0NTI4ODNkNTAxYTNiODk2NWExODliNzIzYjkyNGI3YWI0YTU3YzYzZTgyMGQ0Y2VhNWRlN2MzM2Q0YTkwOGEwYTY4NGY4YjU4Y2ViNjIwMzg0OGYwMGM1OWQ1YTZkOGI0M2M1NTc5MmFiZjVmMmM3MWFiODEsZXlKamJHbGxiblJKWkNJNklpSXNJbTVoYldVaU9pSktjM0J5WldGa2MyaGxaWFFpTENKa1lYUmxJam94TnpVNE56YzBNRFF5TENKa2IyMWhhVzRpT2xzaWFuTndjbVZoWkhOb1pXVjBMbU52YlNJc0ltTnZaR1Z6WVc1a1ltOTRMbWx2SWl3aWFuTm9aV3hzTG01bGRDSXNJbU56WWk1aGNIQWlMQ0p6ZEdGamEySnNhWFI2TG1sdklpd2lkMlZpWTI5dWRHRnBibVZ5TG1sdklpd2lkMlZpSWl3aWJHOWpZV3hvYjNOMElsMHNJbkJzWVc0aU9pSXpOQ0lzSW5OamIzQmxJanBiSW5ZM0lpd2lkamdpTENKMk9TSXNJbll4TUNJc0luWXhNU0lzSW1Ob1lYSjBjeUlzSW1admNtMXpJaXdpWm05eWJYVnNZU0lzSW5CaGNuTmxjaUlzSW5KbGJtUmxjaUlzSW1OdmJXMWxiblJ6SWl3aWFXMXdiM0owWlhJaUxDSmlZWElpTENKMllXeHBaR0YwYVc5dWN5SXNJbk5sWVhKamFDSXNJbkJ5YVc1MElpd2ljMmhsWlhSeklpd2lZMnhwWlc1MElpd2ljMlZ5ZG1WeUlpd2ljMmhoY0dWeklpd2labTl5YldGMElsMHNJbVJsYlc4aU9uUnlkV1Y5');

// Set the extensions
jspreadsheet.setExtensions({ formula });

@Component({
    standalone: true,
    selector: "app-root",
    template: `<div #spreadsheet></div>`
})
export class AppComponent {
    @ViewChild("spreadsheet") spreadsheet: ElementRef;
    // Worksheets
    worksheets: jspreadsheet.worksheetInstance[];

    // Create a new data grid
    ngAfterViewInit() {
        // Create spreadsheet
        this.worksheets = jspreadsheet(this.spreadsheet.nativeElement, {
            worksheets: [{
                data: [
    [
        "Angle (radians)",
        "Tangent"
    ],
    [
        0,
        "=TAN(A2)"
    ],
    [
        0.7854,
        "=TAN(A3)"
    ],
    [
        1.0472,
        "=TAN(A4)"
    ],
    [
        -1.5708,
        "=TAN(A5)"
    ]
]
            }]
        });
    }
}

Edit this page on GitHub