Products

RADIANS function

PRO BASIC

The RADIANS function in Jspreadsheet Formulas Pro is used to convert angles measured in degrees into radians. To understand what a radian is, imagine a circle with a certain radius. If you draw an arc with the same length as the radius, the angle that this arc creates at the center of the circle is equal to one radian. So, by using the RADIANS function, you can easily change an angle from the more commonly used degree measurement to its equivalent in radians.

Documentation

Converts degrees into radians. One radian is equal to the angle made at the center of a circle by an arc whose length is equal to the radius of the circle.

Category

Math and trigonometry

Syntax

RADIANS(angle)

Parameter Description
angle The angle to convert from degrees to radians.

Behavior

The RADIANS function is used to convert an angle measured in degrees to an equivalent measure in radians. It accepts a single argument, which should be a numerical value representing an angle in degrees. The function then returns the equivalent angle in radians.

  • If the cell is empty or contains text, the RADIANS function will return a #VALUE! error.
  • The function treats boolean values as integers before conversion, where TRUE is equivalent to 1 and FALSE is equivalent to 0.
  • If the argument is non-numeric or if the function encounters any error during calculation, it will return an error.

Common Errors

Error Description
#VALUE! This error is displayed when the input cell is empty, contains text, or any non-numeric value.
#NUM! This error is displayed when the function encounters an error during the calculation. For example, if the input is a number, but not an angle in degrees, the function may return this error.

Best practices

  • Always ensure that the input to the RADIANS function represents an angle in degrees. Providing any other numerical value may lead to incorrect results or errors.
  • Avoid using boolean values as inputs as they are treated as integers, which can lead to unexpected results.
  • Handle errors properly by using error handling functions such as 'IFERROR' or 'ISERROR' to avoid disruption in the calculation process. This is especially useful when using the RADIANS function in larger formulas or calculations.
  • Always check the data type of the input to avoid #VALUE! error. It can be avoided by ensuring that the input cell contains a numeric value.

Usage

A few examples using the RADIANS function.

RADIANS(45) returns approximately 0.7854, which is the equivalent angle in radians of 45 degrees  
RADIANS(90) returns approximately 1.5708, which is the equivalent angle in radians of 90 degrees  
RADIANS(A1) returns the equivalent angle in radians of the value in cell A1, which is assumed to be in degrees  

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('YmE2ZTI5M2U1MTMwNTc1ZjNmMmNiNmRmZGI5MzljMWM3MGE5NGY5MmJjMDA0ZmJlYTJhZTQyOTUyZTUyYWVkNWE5NDE3NWI2YzVhNWViNzljZWE0ODZjNTMzNjA1Yjk5NzBmYjA2YjRiOTA1MjQ5NzMyOTg2NjA3YTdkYmEyYjYsZXlKamJHbGxiblJKWkNJNklpSXNJbTVoYldVaU9pSktjM0J5WldGa2MyaGxaWFFpTENKa1lYUmxJam94TnpVMk56a3pNRGsyTENKa2IyMWhhVzRpT2xzaWFuTndjbVZoWkhOb1pXVjBMbU52YlNJc0ltTnZaR1Z6WVc1a1ltOTRMbWx2SWl3aWFuTm9aV3hzTG01bGRDSXNJbU56WWk1aGNIQWlMQ0p6ZEdGamEySnNhWFI2TG1sdklpd2lkMlZpWTI5dWRHRnBibVZ5TG1sdklpd2lkMlZpSWl3aWJHOWpZV3hvYjNOMElsMHNJbkJzWVc0aU9pSXpOQ0lzSW5OamIzQmxJanBiSW5ZM0lpd2lkamdpTENKMk9TSXNJbll4TUNJc0luWXhNU0lzSW1Ob1lYSjBjeUlzSW1admNtMXpJaXdpWm05eWJYVnNZU0lzSW5CaGNuTmxjaUlzSW5KbGJtUmxjaUlzSW1OdmJXMWxiblJ6SWl3aWFXMXdiM0owWlhJaUxDSmlZWElpTENKMllXeHBaR0YwYVc5dWN5SXNJbk5sWVhKamFDSXNJbkJ5YVc1MElpd2ljMmhsWlhSeklpd2lZMnhwWlc1MElpd2ljMlZ5ZG1WeUlpd2ljMmhoY0dWeklpd2labTl5YldGMElsMHNJbVJsYlc4aU9uUnlkV1Y5');

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

// Create a new spreadsheet
jspreadsheet(document.getElementById('spreadsheet'), {
  worksheets: [{
    data: [
    [
        "Degrees",
        "Radians"
    ],
    [
        0,
        "=RADIANS(A2)"
    ],
    [
        30,
        "=RADIANS(A3)"
    ],
    [
        45,
        "=RADIANS(A4)"
    ],
    [
        90,
        "=RADIANS(A5)"
    ],
    [
        180,
        "=RADIANS(A6)"
    ]
]
  }]
});
</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('YmE2ZTI5M2U1MTMwNTc1ZjNmMmNiNmRmZGI5MzljMWM3MGE5NGY5MmJjMDA0ZmJlYTJhZTQyOTUyZTUyYWVkNWE5NDE3NWI2YzVhNWViNzljZWE0ODZjNTMzNjA1Yjk5NzBmYjA2YjRiOTA1MjQ5NzMyOTg2NjA3YTdkYmEyYjYsZXlKamJHbGxiblJKWkNJNklpSXNJbTVoYldVaU9pSktjM0J5WldGa2MyaGxaWFFpTENKa1lYUmxJam94TnpVMk56a3pNRGsyTENKa2IyMWhhVzRpT2xzaWFuTndjbVZoWkhOb1pXVjBMbU52YlNJc0ltTnZaR1Z6WVc1a1ltOTRMbWx2SWl3aWFuTm9aV3hzTG01bGRDSXNJbU56WWk1aGNIQWlMQ0p6ZEdGamEySnNhWFI2TG1sdklpd2lkMlZpWTI5dWRHRnBibVZ5TG1sdklpd2lkMlZpSWl3aWJHOWpZV3hvYjNOMElsMHNJbkJzWVc0aU9pSXpOQ0lzSW5OamIzQmxJanBiSW5ZM0lpd2lkamdpTENKMk9TSXNJbll4TUNJc0luWXhNU0lzSW1Ob1lYSjBjeUlzSW1admNtMXpJaXdpWm05eWJYVnNZU0lzSW5CaGNuTmxjaUlzSW5KbGJtUmxjaUlzSW1OdmJXMWxiblJ6SWl3aWFXMXdiM0owWlhJaUxDSmlZWElpTENKMllXeHBaR0YwYVc5dWN5SXNJbk5sWVhKamFDSXNJbkJ5YVc1MElpd2ljMmhsWlhSeklpd2lZMnhwWlc1MElpd2ljMlZ5ZG1WeUlpd2ljMmhoY0dWeklpd2labTl5YldGMElsMHNJbVJsYlc4aU9uUnlkV1Y5');

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

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

    // Worksheet data
    const data = [
    [
        "Degrees",
        "Radians"
    ],
    [
        0,
        "=RADIANS(A2)"
    ],
    [
        30,
        "=RADIANS(A3)"
    ],
    [
        45,
        "=RADIANS(A4)"
    ],
    [
        90,
        "=RADIANS(A5)"
    ],
    [
        180,
        "=RADIANS(A6)"
    ]
];

    // 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('YmE2ZTI5M2U1MTMwNTc1ZjNmMmNiNmRmZGI5MzljMWM3MGE5NGY5MmJjMDA0ZmJlYTJhZTQyOTUyZTUyYWVkNWE5NDE3NWI2YzVhNWViNzljZWE0ODZjNTMzNjA1Yjk5NzBmYjA2YjRiOTA1MjQ5NzMyOTg2NjA3YTdkYmEyYjYsZXlKamJHbGxiblJKWkNJNklpSXNJbTVoYldVaU9pSktjM0J5WldGa2MyaGxaWFFpTENKa1lYUmxJam94TnpVMk56a3pNRGsyTENKa2IyMWhhVzRpT2xzaWFuTndjbVZoWkhOb1pXVjBMbU52YlNJc0ltTnZaR1Z6WVc1a1ltOTRMbWx2SWl3aWFuTm9aV3hzTG01bGRDSXNJbU56WWk1aGNIQWlMQ0p6ZEdGamEySnNhWFI2TG1sdklpd2lkMlZpWTI5dWRHRnBibVZ5TG1sdklpd2lkMlZpSWl3aWJHOWpZV3hvYjNOMElsMHNJbkJzWVc0aU9pSXpOQ0lzSW5OamIzQmxJanBiSW5ZM0lpd2lkamdpTENKMk9TSXNJbll4TUNJc0luWXhNU0lzSW1Ob1lYSjBjeUlzSW1admNtMXpJaXdpWm05eWJYVnNZU0lzSW5CaGNuTmxjaUlzSW5KbGJtUmxjaUlzSW1OdmJXMWxiblJ6SWl3aWFXMXdiM0owWlhJaUxDSmlZWElpTENKMllXeHBaR0YwYVc5dWN5SXNJbk5sWVhKamFDSXNJbkJ5YVc1MElpd2ljMmhsWlhSeklpd2lZMnhwWlc1MElpd2ljMlZ5ZG1WeUlpd2ljMmhoY0dWeklpd2labTl5YldGMElsMHNJbVJsYlc4aU9uUnlkV1Y5');

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

export default {
    components: {
        Spreadsheet,
        Worksheet,
    },
    data() {
        // Worksheet data
        const data = [
    [
        "Degrees",
        "Radians"
    ],
    [
        0,
        "=RADIANS(A2)"
    ],
    [
        30,
        "=RADIANS(A3)"
    ],
    [
        45,
        "=RADIANS(A4)"
    ],
    [
        90,
        "=RADIANS(A5)"
    ],
    [
        180,
        "=RADIANS(A6)"
    ]
]

        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('YmE2ZTI5M2U1MTMwNTc1ZjNmMmNiNmRmZGI5MzljMWM3MGE5NGY5MmJjMDA0ZmJlYTJhZTQyOTUyZTUyYWVkNWE5NDE3NWI2YzVhNWViNzljZWE0ODZjNTMzNjA1Yjk5NzBmYjA2YjRiOTA1MjQ5NzMyOTg2NjA3YTdkYmEyYjYsZXlKamJHbGxiblJKWkNJNklpSXNJbTVoYldVaU9pSktjM0J5WldGa2MyaGxaWFFpTENKa1lYUmxJam94TnpVMk56a3pNRGsyTENKa2IyMWhhVzRpT2xzaWFuTndjbVZoWkhOb1pXVjBMbU52YlNJc0ltTnZaR1Z6WVc1a1ltOTRMbWx2SWl3aWFuTm9aV3hzTG01bGRDSXNJbU56WWk1aGNIQWlMQ0p6ZEdGamEySnNhWFI2TG1sdklpd2lkMlZpWTI5dWRHRnBibVZ5TG1sdklpd2lkMlZpSWl3aWJHOWpZV3hvYjNOMElsMHNJbkJzWVc0aU9pSXpOQ0lzSW5OamIzQmxJanBiSW5ZM0lpd2lkamdpTENKMk9TSXNJbll4TUNJc0luWXhNU0lzSW1Ob1lYSjBjeUlzSW1admNtMXpJaXdpWm05eWJYVnNZU0lzSW5CaGNuTmxjaUlzSW5KbGJtUmxjaUlzSW1OdmJXMWxiblJ6SWl3aWFXMXdiM0owWlhJaUxDSmlZWElpTENKMllXeHBaR0YwYVc5dWN5SXNJbk5sWVhKamFDSXNJbkJ5YVc1MElpd2ljMmhsWlhSeklpd2lZMnhwWlc1MElpd2ljMlZ5ZG1WeUlpd2ljMmhoY0dWeklpd2labTl5YldGMElsMHNJbVJsYlc4aU9uUnlkV1Y5');

// 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: [
    [
        "Degrees",
        "Radians"
    ],
    [
        0,
        "=RADIANS(A2)"
    ],
    [
        30,
        "=RADIANS(A3)"
    ],
    [
        45,
        "=RADIANS(A4)"
    ],
    [
        90,
        "=RADIANS(A5)"
    ],
    [
        180,
        "=RADIANS(A6)"
    ]
]
            }]
        });
    }
}