POWER function

PRO BASIC

The POWER function in Jspreadsheet Formulas Pro is a beneficial tool that gives you the result of a number raised to a certain power. For instance, if you want to calculate 2 raised to the power of 3, you can use this function and it will return 8, as 222 equals 8. It's a simple and swift way to perform exponential calculations, enhancing the efficiency of your spreadsheet tasks.

Documentation

Returns the result of a number raised to a power.

Syntax

POWER(number, power)

Parameter	Description
`number`	The base number.
`power`	The exponent by which to raise the base.

Behavior

The POWER function is used to raise a number to a specific power. The function takes two arguments: the base number and the exponent. Here's how it handles different types of data:

Numbers: The function works best with numerical data. Both the base and the exponent should be numbers. For example, POWER(2,3) will return 8, as it raises 2 to the power of 3.
Empty Cells: If either the base or the exponent is an empty cell, the function will return an error.
Text: If either the base or the exponent is a text string, the function will return an error, as it expects numerical input.
Booleans: If the function encounters a Boolean value (TRUE or FALSE), it converts TRUE to 1 and FALSE to 0. For example, POWER(TRUE, 3) will return 1.
Errors: If either the base or the exponent contains an error, the POWER function will also return that error.

Common Errors

Error	Description
#VALUE!	This error is displayed when either the base or the exponent is non-numeric.
#NUM!	This error is displayed when the base is a negative number and the exponent is a non-integer.

Best practices

Always ensure that both the base and the exponent are numeric. The POWER function does not work with text strings and may produce unexpected results with Boolean values.

Be aware that the POWER function can handle decimal exponents, but if you provide a negative base with a non-integer exponent, it will return an error.

When using cell references as arguments, make sure those cells contain the expected numeric data to avoid errors.

Use the POWER function to perform complex mathematical operations, but remember that for simple squares and cubes, using ^2 or ^3 can be more straightforward and efficient.

Usage

A few examples using the POWER function.

POWER(2,3) returns 8, which is 2 raised to the power of 3  
POWER(A1,B1) returns the value of cell A1 raised to the power of the value in cell B1  
POWER(10,-2) returns 0.01, which is 10 raised to the power of -2

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

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

// Create a new spreadsheet
jspreadsheet(document.getElementById('spreadsheet'), {
  worksheets: [{
    data: [
    [
        "Base",
        "Exponent",
        "Result"
    ],
    [
        2,
        3,
        "=POWER(A2,B2)"
    ],
    [
        5,
        2,
        "=POWER(A3,B3)"
    ],
    [
        10,
        -1,
        "=POWER(A4,B4)"
    ],
    [
        4,
        0.5,
        "=POWER(A5,B5)"
    ]
]
  }]
});
</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('Mjk3M2Y1ZjA1YTg2OGMzMWNjMTEwYWE3ZmQyZjU0OGE1YjQ5MjA0NDE0ZDkyZTY3NThjOTk4MDQxNjA3NWQ5YzNhNjdhYmJjOWRlZjFhMzZhYzIyMWUyZDU0YTg0NjMxMGE5ZDViYTRlZGM1YjdiZGNkNzhhNWIwYzk4NTE2N2UsZXlKamJHbGxiblJKWkNJNklpSXNJbTVoYldVaU9pSktjM0J5WldGa2MyaGxaWFFpTENKa1lYUmxJam94TnpVNE5qRTNNVE14TENKa2IyMWhhVzRpT2xzaWFuTndjbVZoWkhOb1pXVjBMbU52YlNJc0ltTnZaR1Z6WVc1a1ltOTRMbWx2SWl3aWFuTm9aV3hzTG01bGRDSXNJbU56WWk1aGNIQWlMQ0p6ZEdGamEySnNhWFI2TG1sdklpd2lkMlZpWTI5dWRHRnBibVZ5TG1sdklpd2lkMlZpSWl3aWJHOWpZV3hvYjNOMElsMHNJbkJzWVc0aU9pSXpOQ0lzSW5OamIzQmxJanBiSW5ZM0lpd2lkamdpTENKMk9TSXNJbll4TUNJc0luWXhNU0lzSW1Ob1lYSjBjeUlzSW1admNtMXpJaXdpWm05eWJYVnNZU0lzSW5CaGNuTmxjaUlzSW5KbGJtUmxjaUlzSW1OdmJXMWxiblJ6SWl3aWFXMXdiM0owWlhJaUxDSmlZWElpTENKMllXeHBaR0YwYVc5dWN5SXNJbk5sWVhKamFDSXNJbkJ5YVc1MElpd2ljMmhsWlhSeklpd2lZMnhwWlc1MElpd2ljMlZ5ZG1WeUlpd2ljMmhoY0dWeklpd2labTl5YldGMElsMHNJbVJsYlc4aU9uUnlkV1Y5');

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

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

    // Worksheet data
    const data = [
    [
        "Base",
        "Exponent",
        "Result"
    ],
    [
        2,
        3,
        "=POWER(A2,B2)"
    ],
    [
        5,
        2,
        "=POWER(A3,B3)"
    ],
    [
        10,
        -1,
        "=POWER(A4,B4)"
    ],
    [
        4,
        0.5,
        "=POWER(A5,B5)"
    ]
];

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

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

export default {
    components: {
        Spreadsheet,
        Worksheet,
    },
    data() {
        // Worksheet data
        const data = [
    [
        "Base",
        "Exponent",
        "Result"
    ],
    [
        2,
        3,
        "=POWER(A2,B2)"
    ],
    [
        5,
        2,
        "=POWER(A3,B3)"
    ],
    [
        10,
        -1,
        "=POWER(A4,B4)"
    ],
    [
        4,
        0.5,
        "=POWER(A5,B5)"
    ]
]

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

// 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: [
    [
        "Base",
        "Exponent",
        "Result"
    ],
    [
        2,
        3,
        "=POWER(A2,B2)"
    ],
    [
        5,
        2,
        "=POWER(A3,B3)"
    ],
    [
        10,
        -1,
        "=POWER(A4,B4)"
    ],
    [
        4,
        0.5,
        "=POWER(A5,B5)"
    ]
]
            }]
        });
    }
}

Edit this page on GitHub