IMARGUMENT function

PRO BASIC

The IMARGUMENT function is a feature in Jspreadsheet Formulas Pro that helps you find the argument or phase angle of a complex number, but it does so in radians. A complex number is a number that can be expressed in the form a + bi, where 'a' and 'b' are real numbers and 'i' is the imaginary unit. The phase angle is the angle that is formed by the real axis and the line connecting the point to the origin in a complex plane. By using the IMARGUMENT function, you can easily calculate this angle without any complex manual computations.

Documentation

The IMARGUMENT function is used to return the argument (phase angle) of a complex number in radians.

Syntax

IMARGUMENT(inumber)

Parameter	Description
`inumber`	The complex number for which to find the argument.

Behavior

The IMARGUMENT function calculates the argument theta of a complex number. The argument is the angle of the complex number in the complex plane, in radians. The complex number can be in the format of a+bj or a+bi.

If the cell is empty, the function returns an error.
Text: If the text is not a valid complex number, the function returns an error.
Booleans: Boolean values are not valid inputs for this function and will result in an error.
Errors: If the reference cell contains an error, the IMARGUMENT function will also produce an error.
Real Numbers: If the complex number is a real number (i.e., the imaginary part is zero), the function returns 0 if the real part is positive and Pi if the real part is negative.

Common Errors

Error	Description
#NUM!	Occurs when the provided argument is not a valid complex number.
#VALUE!	Returned when the input is not a valid complex number or when the complex format is missing the imaginary unit (i or j).
#DIV/0!	This error appears when the real and imaginary parts of the complex number are both 0.

Best practices

Always ensure that the cells referenced by the IMARGUMENT function contain valid complex numbers.

Avoid using logical values as they are not valid inputs for the IMARGUMENT function.

Handle errors using error-checking functions like ISERROR or IFERROR to prevent your spreadsheet from breaking.

Remember that the result is in radians. If you need the result in degrees, use another function to convert the result from radians to degrees.

Usage

A few examples using the IMARGUMENT function.

IMARGUMENT("2+2i")       // ≈ 0.7854 radians (π/4)
IMARGUMENT("-3-3i")      // ≈ -2.3562 radians (-3π/4)
IMARGUMENT("5+0i")       // 0 radians (positive real axis)
IMARGUMENT("-5+0i")      // ≈ 3.1416 radians (π, negative real axis)
IMARGUMENT(A1)           // Returns phase angle of complex number in cell A1

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

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

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

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

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

    // Worksheet data
    const data = [
    [
        "Complex Number",
        "Argument (radians)"
    ],
    [
        "3+4i",
        "=IMARGUMENT(A2)"
    ],
    [
        "-1+i",
        "=IMARGUMENT(A3)"
    ],
    [
        "2-2i",
        "=IMARGUMENT(A4)"
    ],
    [
        "-3-3i",
        "=IMARGUMENT(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('NmRkMGJhYjIzZDM5Y2FhMzhlMGEwMjg4NWRkYWMzZDQ3ODNlNGNjNDYyNDc3YzhjMzQ3Yjc3ZDg5NjVlNmE5OWE0ZDI2MGQzNTdjNTJhNjFmZWI5OGRkMDk5NmI4ZTZlYjkwNmZhZDZmNjVkOTJlODhhNWE1MDhhMjJjYjEzMDUsZXlKamJHbGxiblJKWkNJNklpSXNJbTVoYldVaU9pSktjM0J5WldGa2MyaGxaWFFpTENKa1lYUmxJam94TnpVNE56YzBNRE13TENKa2IyMWhhVzRpT2xzaWFuTndjbVZoWkhOb1pXVjBMbU52YlNJc0ltTnZaR1Z6WVc1a1ltOTRMbWx2SWl3aWFuTm9aV3hzTG01bGRDSXNJbU56WWk1aGNIQWlMQ0p6ZEdGamEySnNhWFI2TG1sdklpd2lkMlZpWTI5dWRHRnBibVZ5TG1sdklpd2lkMlZpSWl3aWJHOWpZV3hvYjNOMElsMHNJbkJzWVc0aU9pSXpOQ0lzSW5OamIzQmxJanBiSW5ZM0lpd2lkamdpTENKMk9TSXNJbll4TUNJc0luWXhNU0lzSW1Ob1lYSjBjeUlzSW1admNtMXpJaXdpWm05eWJYVnNZU0lzSW5CaGNuTmxjaUlzSW5KbGJtUmxjaUlzSW1OdmJXMWxiblJ6SWl3aWFXMXdiM0owWlhJaUxDSmlZWElpTENKMllXeHBaR0YwYVc5dWN5SXNJbk5sWVhKamFDSXNJbkJ5YVc1MElpd2ljMmhsWlhSeklpd2lZMnhwWlc1MElpd2ljMlZ5ZG1WeUlpd2ljMmhoY0dWeklpd2labTl5YldGMElsMHNJbVJsYlc4aU9uUnlkV1Y5');

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

export default {
    components: {
        Spreadsheet,
        Worksheet,
    },
    data() {
        // Worksheet data
        const data = [
    [
        "Complex Number",
        "Argument (radians)"
    ],
    [
        "3+4i",
        "=IMARGUMENT(A2)"
    ],
    [
        "-1+i",
        "=IMARGUMENT(A3)"
    ],
    [
        "2-2i",
        "=IMARGUMENT(A4)"
    ],
    [
        "-3-3i",
        "=IMARGUMENT(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('NmRkMGJhYjIzZDM5Y2FhMzhlMGEwMjg4NWRkYWMzZDQ3ODNlNGNjNDYyNDc3YzhjMzQ3Yjc3ZDg5NjVlNmE5OWE0ZDI2MGQzNTdjNTJhNjFmZWI5OGRkMDk5NmI4ZTZlYjkwNmZhZDZmNjVkOTJlODhhNWE1MDhhMjJjYjEzMDUsZXlKamJHbGxiblJKWkNJNklpSXNJbTVoYldVaU9pSktjM0J5WldGa2MyaGxaWFFpTENKa1lYUmxJam94TnpVNE56YzBNRE13TENKa2IyMWhhVzRpT2xzaWFuTndjbVZoWkhOb1pXVjBMbU52YlNJc0ltTnZaR1Z6WVc1a1ltOTRMbWx2SWl3aWFuTm9aV3hzTG01bGRDSXNJbU56WWk1aGNIQWlMQ0p6ZEdGamEySnNhWFI2TG1sdklpd2lkMlZpWTI5dWRHRnBibVZ5TG1sdklpd2lkMlZpSWl3aWJHOWpZV3hvYjNOMElsMHNJbkJzWVc0aU9pSXpOQ0lzSW5OamIzQmxJanBiSW5ZM0lpd2lkamdpTENKMk9TSXNJbll4TUNJc0luWXhNU0lzSW1Ob1lYSjBjeUlzSW1admNtMXpJaXdpWm05eWJYVnNZU0lzSW5CaGNuTmxjaUlzSW5KbGJtUmxjaUlzSW1OdmJXMWxiblJ6SWl3aWFXMXdiM0owWlhJaUxDSmlZWElpTENKMllXeHBaR0YwYVc5dWN5SXNJbk5sWVhKamFDSXNJbkJ5YVc1MElpd2ljMmhsWlhSeklpd2lZMnhwWlc1MElpd2ljMlZ5ZG1WeUlpd2ljMmhoY0dWeklpd2labTl5YldGMElsMHNJbVJsYlc4aU9uUnlkV1Y5');

// 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",
        "Argument (radians)"
    ],
    [
        "3+4i",
        "=IMARGUMENT(A2)"
    ],
    [
        "-1+i",
        "=IMARGUMENT(A3)"
    ],
    [
        "2-2i",
        "=IMARGUMENT(A4)"
    ],
    [
        "-3-3i",
        "=IMARGUMENT(A5)"
    ]
]
            }]
        });
    }
}

Edit this page on GitHub