MAXA function

PRO BASIC

The MAXA function in Jspreadsheet Formulas Pro is used to find the largest value within a specified range of cells or an array. This is particularly useful when dealing with a large set of numerical data and you want to quickly identify the highest number. The function scans through all the data in the selected range or array and returns the highest value it finds. Keep in mind, it also considers logical values and text representing numbers in its evaluation.

Documentation

Returns the largest value in a range of cells or an array.

Syntax

MAXA(number1, [number2], ...)

Parameter	Description
`number1`	The first number, cell reference, or range of numbers that you want to find the maximum value for.
`numberN`	Optional. Additional numbers, cell references, or ranges of numbers to evaluate. Multiple arguments can be included.

Behavior

The MAXA function is used to return the maximum numeric value in a dataset, where text representations of numbers are also counted. It behaves in the following ways:

For numeric data, it returns the highest value.
It interprets text representations of numbers as numbers. For example, it reads '10' as 10.
It interprets boolean values TRUE and FALSE as 1 and 0 respectively.
It ignores empty cells.
Non-numeric text that is not a valid number representation is treated as zero.
If the dataset contains only text and no numbers, boolean values or text representations of numbers, MAXA returns zero.
If the dataset contains error values, the function will return an error.

Common Errors

Error	Description
#VALUE!	This error occurs if an invalid argument type is passed directly (e.g., a malformed formula), not because of plain non-numeric text in the range.
#REF!	If the cell references are not valid (for example, deleted cells), the function will return a `#REF!` error.

Best practices

Use the MAXA function when you want to consider logical values and text representations of numbers in your dataset. If you only have numeric data, use the MAX function instead.

Be careful while using MAXA in large datasets as it can slow down the calculation process due to its ability to interpret text representations of numbers.

Avoid using the MAXA function on a range that includes error values as it will return an error.

Usage

A few examples using the MAXA function.

MAXA(A1:A10) returns the largest value in the range A1:A10  
MAXA(B1:C5) returns the largest value in the array B1:C5  
MAXA(10, 20, 30) returns the number 30, which is the largest value among the arguments.

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

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

// Create a new spreadsheet
jspreadsheet(document.getElementById('spreadsheet'), {
  worksheets: [{
    data: [
    [
        "Quarter 1",
        "Quarter 2",
        "Quarter 3",
        "Highest Quarter"
    ],
    [
        25000,
        32000,
        28000,
        "=MAXA(A2:C2)"
    ],
    [
        18000,
        22000,
        35000,
        "=MAXA(A3:C3)"
    ],
    [
        30000,
        27000,
        31000,
        "=MAXA(A4:C4)"
    ],
    [
        "Overall Max",
        "",
        "",
        "=MAXA(A2:C4)"
    ]
]
  }]
});
</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('MzU2NWQxY2FmNTQyYzhhNDYwYzQxYzkzNDlhM2E0MDJhNjI5ZjQ3M2ZjZjZiNTkxYTk4YWIyYzA4MmZkNGU4ZTUyOTJjNDMyZmEzODM4ZDY5YzEwM2M2MmI2MmM2YzgyZDFhYWRmNGQzZTMxYzBjNmY4YjNiMDc0MTdiZjNmMmQsZXlKamJHbGxiblJKWkNJNklpSXNJbTVoYldVaU9pSktjM0J5WldGa2MyaGxaWFFpTENKa1lYUmxJam94TnpVNE56Y3pPVFExTENKa2IyMWhhVzRpT2xzaWFuTndjbVZoWkhOb1pXVjBMbU52YlNJc0ltTnZaR1Z6WVc1a1ltOTRMbWx2SWl3aWFuTm9aV3hzTG01bGRDSXNJbU56WWk1aGNIQWlMQ0p6ZEdGamEySnNhWFI2TG1sdklpd2lkMlZpWTI5dWRHRnBibVZ5TG1sdklpd2lkMlZpSWl3aWJHOWpZV3hvYjNOMElsMHNJbkJzWVc0aU9pSXpOQ0lzSW5OamIzQmxJanBiSW5ZM0lpd2lkamdpTENKMk9TSXNJbll4TUNJc0luWXhNU0lzSW1Ob1lYSjBjeUlzSW1admNtMXpJaXdpWm05eWJYVnNZU0lzSW5CaGNuTmxjaUlzSW5KbGJtUmxjaUlzSW1OdmJXMWxiblJ6SWl3aWFXMXdiM0owWlhJaUxDSmlZWElpTENKMllXeHBaR0YwYVc5dWN5SXNJbk5sWVhKamFDSXNJbkJ5YVc1MElpd2ljMmhsWlhSeklpd2lZMnhwWlc1MElpd2ljMlZ5ZG1WeUlpd2ljMmhoY0dWeklpd2labTl5YldGMElsMHNJbVJsYlc4aU9uUnlkV1Y5');

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

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

    // Worksheet data
    const data = [
    [
        "Quarter 1",
        "Quarter 2",
        "Quarter 3",
        "Highest Quarter"
    ],
    [
        25000,
        32000,
        28000,
        "=MAXA(A2:C2)"
    ],
    [
        18000,
        22000,
        35000,
        "=MAXA(A3:C3)"
    ],
    [
        30000,
        27000,
        31000,
        "=MAXA(A4:C4)"
    ],
    [
        "Overall Max",
        "",
        "",
        "=MAXA(A2:C4)"
    ]
];

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

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

export default {
    components: {
        Spreadsheet,
        Worksheet,
    },
    data() {
        // Worksheet data
        const data = [
    [
        "Quarter 1",
        "Quarter 2",
        "Quarter 3",
        "Highest Quarter"
    ],
    [
        25000,
        32000,
        28000,
        "=MAXA(A2:C2)"
    ],
    [
        18000,
        22000,
        35000,
        "=MAXA(A3:C3)"
    ],
    [
        30000,
        27000,
        31000,
        "=MAXA(A4:C4)"
    ],
    [
        "Overall Max",
        "",
        "",
        "=MAXA(A2:C4)"
    ]
]

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

// 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: [
    [
        "Quarter 1",
        "Quarter 2",
        "Quarter 3",
        "Highest Quarter"
    ],
    [
        25000,
        32000,
        28000,
        "=MAXA(A2:C2)"
    ],
    [
        18000,
        22000,
        35000,
        "=MAXA(A3:C3)"
    ],
    [
        30000,
        27000,
        31000,
        "=MAXA(A4:C4)"
    ],
    [
        "Overall Max",
        "",
        "",
        "=MAXA(A2:C4)"
    ]
]
            }]
        });
    }
}

Edit this page on GitHub