IMSINH function

PRO BASIC

In Jspreadsheet Formulas Pro, the IMSINH function is used to calculate the hyperbolic sine of a complex number. This means it can handle numbers that have both a real part and an imaginary part. You simply input the complex number into the function, and it will return the hyperbolic sine value of that number. This is particularly useful in advanced mathematical computations involving complex numbers.

Documentation

Returns the hyperbolic sine of a complex number.

Syntax

IMSINH(inumber)

Parameter	Description
`inumber`	The complex number for which you want to calculate the hyperbolic sine.

Behavior

The IMSINH function calculates the inverse hyperbolic sine of a complex number. The complex number to calculate is supplied as a text string in the format "x+yi" or "x+yj".

Here are the behaviors to expect:

If the cell reference or the argument is an empty cell, the IMSINH function will return a #VALUE! error.
If the cell reference or the argument is a text that can't be interpreted as a complex number, the IMSINH function will return a #VALUE! error.
The function doesn't support boolean values. If a boolean value is provided as the argument, the function will treat it as an integer (TRUE as 1 and FALSE as 0).
If the cell reference or the argument is an error, the IMSINH function will return the same error.
If the cell reference or the argument is a number, the IMSINH function will treat it as a real number and calculate the inverse hyperbolic sine.

Common Errors

Error	Description
#VALUE!	Occurs if the supplied argument cannot be interpreted as a complex number.

Best practices

Always ensure the complex number is input as a string in the format "x+yi" or "x+yj". If not, the IMSINH function will return a #VALUE! error.

Use error handling functions like IFERROR or ISERROR to handle possible errors that might arise from using the IMSINH function.

Remember that the IMSINH function is for complex numbers. For real numbers, use the ASINH function.

Ensure that the IMSINH function is spelled correctly to prevent the #NAME? error.

Usage

A few examples using the IMSINH function.

IMSINH("1+i") returns 0.634963914784736+1.29845758141598i
IMSINH("2+3i") returns -3.59056458998578+0.53092108624852i
IMSINH("0+2i") returns 0.909297426825682i
IMSINH(2) returns 3.62686040784702  // Treated as real number

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

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

// Create a new spreadsheet
jspreadsheet(document.getElementById('spreadsheet'), {
  worksheets: [{
    data: [
    [
        "Complex Number",
        "Hyperbolic Sine"
    ],
    [
        "1+i",
        "=IMSINH(A2)"
    ],
    [
        "2-3i",
        "=IMSINH(A3)"
    ],
    [
        "0.5+2i",
        "=IMSINH(A4)"
    ],
    [
        "-1+0.5i",
        "=IMSINH(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('ZGRkODc0MmUwZTcwYzkzNDI3ZWJlYTkyNmQ4Y2Q5ZTA0ZmI3YThiYTVmODAwZmM0YzgzMzdjNTc3ODliY2ZkYjRhZDk1YWQwYzlmMzYwZWExZjAxODA1MjRmOGI0N2ExNTc2ODAzYmIyZGNiNDZiYzQ4YjQ5N2RiOGZhNWY2ZDMsZXlKamJHbGxiblJKWkNJNklpSXNJbTVoYldVaU9pSktjM0J5WldGa2MyaGxaWFFpTENKa1lYUmxJam94TnpVNE56Y3pPVFEyTENKa2IyMWhhVzRpT2xzaWFuTndjbVZoWkhOb1pXVjBMbU52YlNJc0ltTnZaR1Z6WVc1a1ltOTRMbWx2SWl3aWFuTm9aV3hzTG01bGRDSXNJbU56WWk1aGNIQWlMQ0p6ZEdGamEySnNhWFI2TG1sdklpd2lkMlZpWTI5dWRHRnBibVZ5TG1sdklpd2lkMlZpSWl3aWJHOWpZV3hvYjNOMElsMHNJbkJzWVc0aU9pSXpOQ0lzSW5OamIzQmxJanBiSW5ZM0lpd2lkamdpTENKMk9TSXNJbll4TUNJc0luWXhNU0lzSW1Ob1lYSjBjeUlzSW1admNtMXpJaXdpWm05eWJYVnNZU0lzSW5CaGNuTmxjaUlzSW5KbGJtUmxjaUlzSW1OdmJXMWxiblJ6SWl3aWFXMXdiM0owWlhJaUxDSmlZWElpTENKMllXeHBaR0YwYVc5dWN5SXNJbk5sWVhKamFDSXNJbkJ5YVc1MElpd2ljMmhsWlhSeklpd2lZMnhwWlc1MElpd2ljMlZ5ZG1WeUlpd2ljMmhoY0dWeklpd2labTl5YldGMElsMHNJbVJsYlc4aU9uUnlkV1Y5');

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

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

    // Worksheet data
    const data = [
    [
        "Complex Number",
        "Hyperbolic Sine"
    ],
    [
        "1+i",
        "=IMSINH(A2)"
    ],
    [
        "2-3i",
        "=IMSINH(A3)"
    ],
    [
        "0.5+2i",
        "=IMSINH(A4)"
    ],
    [
        "-1+0.5i",
        "=IMSINH(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('ZGRkODc0MmUwZTcwYzkzNDI3ZWJlYTkyNmQ4Y2Q5ZTA0ZmI3YThiYTVmODAwZmM0YzgzMzdjNTc3ODliY2ZkYjRhZDk1YWQwYzlmMzYwZWExZjAxODA1MjRmOGI0N2ExNTc2ODAzYmIyZGNiNDZiYzQ4YjQ5N2RiOGZhNWY2ZDMsZXlKamJHbGxiblJKWkNJNklpSXNJbTVoYldVaU9pSktjM0J5WldGa2MyaGxaWFFpTENKa1lYUmxJam94TnpVNE56Y3pPVFEyTENKa2IyMWhhVzRpT2xzaWFuTndjbVZoWkhOb1pXVjBMbU52YlNJc0ltTnZaR1Z6WVc1a1ltOTRMbWx2SWl3aWFuTm9aV3hzTG01bGRDSXNJbU56WWk1aGNIQWlMQ0p6ZEdGamEySnNhWFI2TG1sdklpd2lkMlZpWTI5dWRHRnBibVZ5TG1sdklpd2lkMlZpSWl3aWJHOWpZV3hvYjNOMElsMHNJbkJzWVc0aU9pSXpOQ0lzSW5OamIzQmxJanBiSW5ZM0lpd2lkamdpTENKMk9TSXNJbll4TUNJc0luWXhNU0lzSW1Ob1lYSjBjeUlzSW1admNtMXpJaXdpWm05eWJYVnNZU0lzSW5CaGNuTmxjaUlzSW5KbGJtUmxjaUlzSW1OdmJXMWxiblJ6SWl3aWFXMXdiM0owWlhJaUxDSmlZWElpTENKMllXeHBaR0YwYVc5dWN5SXNJbk5sWVhKamFDSXNJbkJ5YVc1MElpd2ljMmhsWlhSeklpd2lZMnhwWlc1MElpd2ljMlZ5ZG1WeUlpd2ljMmhoY0dWeklpd2labTl5YldGMElsMHNJbVJsYlc4aU9uUnlkV1Y5');

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

export default {
    components: {
        Spreadsheet,
        Worksheet,
    },
    data() {
        // Worksheet data
        const data = [
    [
        "Complex Number",
        "Hyperbolic Sine"
    ],
    [
        "1+i",
        "=IMSINH(A2)"
    ],
    [
        "2-3i",
        "=IMSINH(A3)"
    ],
    [
        "0.5+2i",
        "=IMSINH(A4)"
    ],
    [
        "-1+0.5i",
        "=IMSINH(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('ZGRkODc0MmUwZTcwYzkzNDI3ZWJlYTkyNmQ4Y2Q5ZTA0ZmI3YThiYTVmODAwZmM0YzgzMzdjNTc3ODliY2ZkYjRhZDk1YWQwYzlmMzYwZWExZjAxODA1MjRmOGI0N2ExNTc2ODAzYmIyZGNiNDZiYzQ4YjQ5N2RiOGZhNWY2ZDMsZXlKamJHbGxiblJKWkNJNklpSXNJbTVoYldVaU9pSktjM0J5WldGa2MyaGxaWFFpTENKa1lYUmxJam94TnpVNE56Y3pPVFEyTENKa2IyMWhhVzRpT2xzaWFuTndjbVZoWkhOb1pXVjBMbU52YlNJc0ltTnZaR1Z6WVc1a1ltOTRMbWx2SWl3aWFuTm9aV3hzTG01bGRDSXNJbU56WWk1aGNIQWlMQ0p6ZEdGamEySnNhWFI2TG1sdklpd2lkMlZpWTI5dWRHRnBibVZ5TG1sdklpd2lkMlZpSWl3aWJHOWpZV3hvYjNOMElsMHNJbkJzWVc0aU9pSXpOQ0lzSW5OamIzQmxJanBiSW5ZM0lpd2lkamdpTENKMk9TSXNJbll4TUNJc0luWXhNU0lzSW1Ob1lYSjBjeUlzSW1admNtMXpJaXdpWm05eWJYVnNZU0lzSW5CaGNuTmxjaUlzSW5KbGJtUmxjaUlzSW1OdmJXMWxiblJ6SWl3aWFXMXdiM0owWlhJaUxDSmlZWElpTENKMllXeHBaR0YwYVc5dWN5SXNJbk5sWVhKamFDSXNJbkJ5YVc1MElpd2ljMmhsWlhSeklpd2lZMnhwWlc1MElpd2ljMlZ5ZG1WeUlpd2ljMmhoY0dWeklpd2labTl5YldGMElsMHNJbVJsYlc4aU9uUnlkV1Y5');

// 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: [
    [
        "Complex Number",
        "Hyperbolic Sine"
    ],
    [
        "1+i",
        "=IMSINH(A2)"
    ],
    [
        "2-3i",
        "=IMSINH(A3)"
    ],
    [
        "0.5+2i",
        "=IMSINH(A4)"
    ],
    [
        "-1+0.5i",
        "=IMSINH(A5)"
    ]
]
            }]
        });
    }
}

Edit this page on GitHub