SINH function
PRO
BASIC
The SINH
function in Jspreadsheet Formulas Pro is a mathematical tool that helps you find the hyperbolic sine of a number. Essentially, it calculates and returns the hyperbolic sine of a given number. This function can be beneficial when dealing with complex mathematical calculations, especially those involving hyperbolic trigonometric functions. To use it, you simply input the number or cell reference you want to find the hyperbolic sine for within the parentheses: SINH(number)
.
Documentation
Returns the hyperbolic sine of a number.
Category
Math and trigonometry
Syntax
SINH(x)
Parameter | Description |
---|---|
x |
The number for which to calculate the hyperbolic sine. |
Behavior
The SINH
function returns the hyperbolic sine of a given number. The hyperbolic sine is calculated as (e^x - e^-x) / 2
, where e
is Euler's number and x
is the given input.`
Here's how it handles different types of inputs:
- Empty cells: If the
SINH
function is given an empty cell, it will treat it as zero and will return zero as the result. - Text: If a text string is provided as an argument, the function will return a
#VALUE!
error, indicating that the input value type is incompatible. - Booleans: If a boolean value is provided to the
SINH
function, it will treatTRUE
as 1 andFALSE
as 0. The corresponding hyperbolic sine value will be returned. - Errors: If the
SINH
function encounters an error value as its argument, it will propagate the error. For example, if#N/A
error is given as an input,#N/A
will be the output.
Common Errors
Error | Description |
---|---|
#VALUE! | This error occurs when the given argument is non-numeric, such as a text string. |
Best practices
- Always make sure to provide numeric values as input to the
SINH
function to avoid#VALUE!
errors.- Be aware that
SINH
treats boolean values as numbers. If your data contains boolean values, you may want to convert them to appropriate numeric values before applyingSINH
.- Remember that
SINH
will propagate any error values from its arguments. Ensure your data is clean and error-free before applying this function.- Use the
SINH
function with other mathematical functions to create complex formulas where needed, but be mindful of the order of operations.
Usage
A few examples using the SINH function.
SINH(0) returns 0
SINH(1) returns approximately 1.1752
SINH(-2) returns approximately -3.62686
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('NWRkNGUxNmZiZjY1NDllN2YyYWVmYjUxMGMxMTYyMWYxNjRmZTg0MjZhNzk3MmJiYjIyYjVlMjdhMzFkYWY3YjRiZmVmOGI4ZTc2MDlhODlkM2YzMmMxNDgzMmVlYTNiNDYyZDk0MjNmNjEyNTg5YWE1ZjU3NWFjNjY0NWZhZDIsZXlKamJHbGxiblJKWkNJNklpSXNJbTVoYldVaU9pSktjM0J5WldGa2MyaGxaWFFpTENKa1lYUmxJam94TnpVMk56a3lOek15TENKa2IyMWhhVzRpT2xzaWFuTndjbVZoWkhOb1pXVjBMbU52YlNJc0ltTnZaR1Z6WVc1a1ltOTRMbWx2SWl3aWFuTm9aV3hzTG01bGRDSXNJbU56WWk1aGNIQWlMQ0p6ZEdGamEySnNhWFI2TG1sdklpd2lkMlZpWTI5dWRHRnBibVZ5TG1sdklpd2lkMlZpSWl3aWJHOWpZV3hvYjNOMElsMHNJbkJzWVc0aU9pSXpOQ0lzSW5OamIzQmxJanBiSW5ZM0lpd2lkamdpTENKMk9TSXNJbll4TUNJc0luWXhNU0lzSW1Ob1lYSjBjeUlzSW1admNtMXpJaXdpWm05eWJYVnNZU0lzSW5CaGNuTmxjaUlzSW5KbGJtUmxjaUlzSW1OdmJXMWxiblJ6SWl3aWFXMXdiM0owWlhJaUxDSmlZWElpTENKMllXeHBaR0YwYVc5dWN5SXNJbk5sWVhKamFDSXNJbkJ5YVc1MElpd2ljMmhsWlhSeklpd2lZMnhwWlc1MElpd2ljMlZ5ZG1WeUlpd2ljMmhoY0dWeklpd2labTl5YldGMElsMHNJbVJsYlc4aU9uUnlkV1Y5');
// Set the extensions
jspreadsheet.setExtensions({ formula });
// Create a new spreadsheet
jspreadsheet(document.getElementById('spreadsheet'), {
worksheets: [{
data: [
[
"x",
"SINH(x)",
"Description"
],
[
0,
"=SINH(A2)",
"Hyperbolic sine of 0"
],
[
1,
"=SINH(A3)",
"Hyperbolic sine of 1"
],
[
-2,
"=SINH(A4)",
"Hyperbolic sine of -2"
],
[
0.5,
"=SINH(A5)",
"Hyperbolic sine of 0.5"
]
]
}]
});
</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('NWRkNGUxNmZiZjY1NDllN2YyYWVmYjUxMGMxMTYyMWYxNjRmZTg0MjZhNzk3MmJiYjIyYjVlMjdhMzFkYWY3YjRiZmVmOGI4ZTc2MDlhODlkM2YzMmMxNDgzMmVlYTNiNDYyZDk0MjNmNjEyNTg5YWE1ZjU3NWFjNjY0NWZhZDIsZXlKamJHbGxiblJKWkNJNklpSXNJbTVoYldVaU9pSktjM0J5WldGa2MyaGxaWFFpTENKa1lYUmxJam94TnpVMk56a3lOek15TENKa2IyMWhhVzRpT2xzaWFuTndjbVZoWkhOb1pXVjBMbU52YlNJc0ltTnZaR1Z6WVc1a1ltOTRMbWx2SWl3aWFuTm9aV3hzTG01bGRDSXNJbU56WWk1aGNIQWlMQ0p6ZEdGamEySnNhWFI2TG1sdklpd2lkMlZpWTI5dWRHRnBibVZ5TG1sdklpd2lkMlZpSWl3aWJHOWpZV3hvYjNOMElsMHNJbkJzWVc0aU9pSXpOQ0lzSW5OamIzQmxJanBiSW5ZM0lpd2lkamdpTENKMk9TSXNJbll4TUNJc0luWXhNU0lzSW1Ob1lYSjBjeUlzSW1admNtMXpJaXdpWm05eWJYVnNZU0lzSW5CaGNuTmxjaUlzSW5KbGJtUmxjaUlzSW1OdmJXMWxiblJ6SWl3aWFXMXdiM0owWlhJaUxDSmlZWElpTENKMllXeHBaR0YwYVc5dWN5SXNJbk5sWVhKamFDSXNJbkJ5YVc1MElpd2ljMmhsWlhSeklpd2lZMnhwWlc1MElpd2ljMlZ5ZG1WeUlpd2ljMmhoY0dWeklpd2labTl5YldGMElsMHNJbVJsYlc4aU9uUnlkV1Y5');
// Set the extensions
jspreadsheet.setExtensions({ formula });
export default function App() {
// Spreadsheet array of worksheets
const spreadsheet = useRef();
// Worksheet data
const data = [
[
"x",
"SINH(x)",
"Description"
],
[
0,
"=SINH(A2)",
"Hyperbolic sine of 0"
],
[
1,
"=SINH(A3)",
"Hyperbolic sine of 1"
],
[
-2,
"=SINH(A4)",
"Hyperbolic sine of -2"
],
[
0.5,
"=SINH(A5)",
"Hyperbolic sine of 0.5"
]
];
// 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('NWRkNGUxNmZiZjY1NDllN2YyYWVmYjUxMGMxMTYyMWYxNjRmZTg0MjZhNzk3MmJiYjIyYjVlMjdhMzFkYWY3YjRiZmVmOGI4ZTc2MDlhODlkM2YzMmMxNDgzMmVlYTNiNDYyZDk0MjNmNjEyNTg5YWE1ZjU3NWFjNjY0NWZhZDIsZXlKamJHbGxiblJKWkNJNklpSXNJbTVoYldVaU9pSktjM0J5WldGa2MyaGxaWFFpTENKa1lYUmxJam94TnpVMk56a3lOek15TENKa2IyMWhhVzRpT2xzaWFuTndjbVZoWkhOb1pXVjBMbU52YlNJc0ltTnZaR1Z6WVc1a1ltOTRMbWx2SWl3aWFuTm9aV3hzTG01bGRDSXNJbU56WWk1aGNIQWlMQ0p6ZEdGamEySnNhWFI2TG1sdklpd2lkMlZpWTI5dWRHRnBibVZ5TG1sdklpd2lkMlZpSWl3aWJHOWpZV3hvYjNOMElsMHNJbkJzWVc0aU9pSXpOQ0lzSW5OamIzQmxJanBiSW5ZM0lpd2lkamdpTENKMk9TSXNJbll4TUNJc0luWXhNU0lzSW1Ob1lYSjBjeUlzSW1admNtMXpJaXdpWm05eWJYVnNZU0lzSW5CaGNuTmxjaUlzSW5KbGJtUmxjaUlzSW1OdmJXMWxiblJ6SWl3aWFXMXdiM0owWlhJaUxDSmlZWElpTENKMllXeHBaR0YwYVc5dWN5SXNJbk5sWVhKamFDSXNJbkJ5YVc1MElpd2ljMmhsWlhSeklpd2lZMnhwWlc1MElpd2ljMlZ5ZG1WeUlpd2ljMmhoY0dWeklpd2labTl5YldGMElsMHNJbVJsYlc4aU9uUnlkV1Y5');
// Set the extensions
jspreadsheet.setExtensions({ formula });
export default {
components: {
Spreadsheet,
Worksheet,
},
data() {
// Worksheet data
const data = [
[
"x",
"SINH(x)",
"Description"
],
[
0,
"=SINH(A2)",
"Hyperbolic sine of 0"
],
[
1,
"=SINH(A3)",
"Hyperbolic sine of 1"
],
[
-2,
"=SINH(A4)",
"Hyperbolic sine of -2"
],
[
0.5,
"=SINH(A5)",
"Hyperbolic sine of 0.5"
]
]
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('NWRkNGUxNmZiZjY1NDllN2YyYWVmYjUxMGMxMTYyMWYxNjRmZTg0MjZhNzk3MmJiYjIyYjVlMjdhMzFkYWY3YjRiZmVmOGI4ZTc2MDlhODlkM2YzMmMxNDgzMmVlYTNiNDYyZDk0MjNmNjEyNTg5YWE1ZjU3NWFjNjY0NWZhZDIsZXlKamJHbGxiblJKWkNJNklpSXNJbTVoYldVaU9pSktjM0J5WldGa2MyaGxaWFFpTENKa1lYUmxJam94TnpVMk56a3lOek15TENKa2IyMWhhVzRpT2xzaWFuTndjbVZoWkhOb1pXVjBMbU52YlNJc0ltTnZaR1Z6WVc1a1ltOTRMbWx2SWl3aWFuTm9aV3hzTG01bGRDSXNJbU56WWk1aGNIQWlMQ0p6ZEdGamEySnNhWFI2TG1sdklpd2lkMlZpWTI5dWRHRnBibVZ5TG1sdklpd2lkMlZpSWl3aWJHOWpZV3hvYjNOMElsMHNJbkJzWVc0aU9pSXpOQ0lzSW5OamIzQmxJanBiSW5ZM0lpd2lkamdpTENKMk9TSXNJbll4TUNJc0luWXhNU0lzSW1Ob1lYSjBjeUlzSW1admNtMXpJaXdpWm05eWJYVnNZU0lzSW5CaGNuTmxjaUlzSW5KbGJtUmxjaUlzSW1OdmJXMWxiblJ6SWl3aWFXMXdiM0owWlhJaUxDSmlZWElpTENKMllXeHBaR0YwYVc5dWN5SXNJbk5sWVhKamFDSXNJbkJ5YVc1MElpd2ljMmhsWlhSeklpd2lZMnhwWlc1MElpd2ljMlZ5ZG1WeUlpd2ljMmhoY0dWeklpd2labTl5YldGMElsMHNJbVJsYlc4aU9uUnlkV1Y5');
// 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: [
[
"x",
"SINH(x)",
"Description"
],
[
0,
"=SINH(A2)",
"Hyperbolic sine of 0"
],
[
1,
"=SINH(A3)",
"Hyperbolic sine of 1"
],
[
-2,
"=SINH(A4)",
"Hyperbolic sine of -2"
],
[
0.5,
"=SINH(A5)",
"Hyperbolic sine of 0.5"
]
]
}]
});
}
}