Products

BAHTTEXT function

The BAHTTEXT function in Jspreadsheet Formulas Pro is a valuable tool for those dealing with Thai currency. This function takes a numerical input and converts it into Thai text, automatically appending the word 'Baht' at the end to denote the currency. It's a simple and efficient way to ensure accuracy and clarity when working with financial data in Thailand. This function makes it easier for users to read and understand the currency values in the spreadsheet.

Documentation

Converts a number to Thai text, automatically appending a suffix to denote currency in Baht.

Category

Text

Syntax

BAHTTEXT(number)

Parameter Description
number The number to be converted to Thai text. Must be between -922,337,203,685,477.58 and 922,337,203,685,477.58.

Behavior

The 'BAHTTEXT' function is used to convert a number to text, in the form of Thai currency (Baht). It takes one argument, which is the number you wish to convert to text. The function returns a string that represents the number in Thai words. Here's how it handles various situations:

  • Numbers: The function works well with numbers and is able to convert them into Thai text representation of Baht. Note that decimals are rounded to the nearest integer.
  • Empty cells: If the function refers to an empty cell, it will consider it as zero and return the Thai word for zero Baht.
  • Text: If the function refers to a cell containing text, it will return an error because it expects a numerical input.
  • Booleans: If the function refers to a cell containing a Boolean value (TRUE or FALSE), it will consider TRUE as 1 and FALSE as 0, and return their corresponding Thai words.
  • Errors: If the function refers to a cell containing an error, it will propagate that error.

Common Errors

Error Description
#VALUE! The function encounters this error when the input argument is non-numeric.
#REF! This error is encountered when the cell reference is not valid.

Best practices

  • Since the BAHTTEXT function only takes numerical values, always make sure the referenced cell contains a number.
  • Keep in mind that this function rounds decimals to the nearest integer. If you need precision, this function may not be the best choice.
  • Be aware that the BAHTTEXT function is not available in all versions of spreadsheet programs. Always ensure it is supported in your version before using it.
  • Use error handling functions to manage potential errors, especially when working with a range of cells.

Usage

A few examples using the BAHTTEXT function.

BAHTTEXT(1234.56) returns "หนึ่งพันสองร้อยสามสิบสี่บาทห้าสิบหกสตางค์"  

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

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

// Create a new spreadsheet
jspreadsheet(document.getElementById('spreadsheet'), {
  worksheets: [{
    data: [
    [
        "Amount",
        "Thai Baht Text"
    ],
    [
        1234.56,
        "=BAHTTEXT(A2)"
    ],
    [
        5000,
        "=BAHTTEXT(A3)"
    ],
    [
        250.75,
        "=BAHTTEXT(A4)"
    ],
    [
        10000,
        "=BAHTTEXT(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('NWFhZjZiNWQwMmExODA2YWQwMTllNDYyMzkxNDRiYjdhZGYyN2ZiMGY3ZWVlYmVjNGZjODhhM2RkODFiOWUwMzMwNjkwN2IzYTJjNjZmZTFkMzQyNGExZjNhZTdjMWRhOGU2Y2I5YzYzMWRmMzA4ZTliMzU1NzZiY2EzNWM5MjAsZXlKamJHbGxiblJKWkNJNklpSXNJbTVoYldVaU9pSktjM0J5WldGa2MyaGxaWFFpTENKa1lYUmxJam94TnpVM01ETXhNVGN4TENKa2IyMWhhVzRpT2xzaWFuTndjbVZoWkhOb1pXVjBMbU52YlNJc0ltTnZaR1Z6WVc1a1ltOTRMbWx2SWl3aWFuTm9aV3hzTG01bGRDSXNJbU56WWk1aGNIQWlMQ0p6ZEdGamEySnNhWFI2TG1sdklpd2lkMlZpWTI5dWRHRnBibVZ5TG1sdklpd2lkMlZpSWl3aWJHOWpZV3hvYjNOMElsMHNJbkJzWVc0aU9pSXpOQ0lzSW5OamIzQmxJanBiSW5ZM0lpd2lkamdpTENKMk9TSXNJbll4TUNJc0luWXhNU0lzSW1Ob1lYSjBjeUlzSW1admNtMXpJaXdpWm05eWJYVnNZU0lzSW5CaGNuTmxjaUlzSW5KbGJtUmxjaUlzSW1OdmJXMWxiblJ6SWl3aWFXMXdiM0owWlhJaUxDSmlZWElpTENKMllXeHBaR0YwYVc5dWN5SXNJbk5sWVhKamFDSXNJbkJ5YVc1MElpd2ljMmhsWlhSeklpd2lZMnhwWlc1MElpd2ljMlZ5ZG1WeUlpd2ljMmhoY0dWeklpd2labTl5YldGMElsMHNJbVJsYlc4aU9uUnlkV1Y5');

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

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

    // Worksheet data
    const data = [
    [
        "Amount",
        "Thai Baht Text"
    ],
    [
        1234.56,
        "=BAHTTEXT(A2)"
    ],
    [
        5000,
        "=BAHTTEXT(A3)"
    ],
    [
        250.75,
        "=BAHTTEXT(A4)"
    ],
    [
        10000,
        "=BAHTTEXT(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('NWFhZjZiNWQwMmExODA2YWQwMTllNDYyMzkxNDRiYjdhZGYyN2ZiMGY3ZWVlYmVjNGZjODhhM2RkODFiOWUwMzMwNjkwN2IzYTJjNjZmZTFkMzQyNGExZjNhZTdjMWRhOGU2Y2I5YzYzMWRmMzA4ZTliMzU1NzZiY2EzNWM5MjAsZXlKamJHbGxiblJKWkNJNklpSXNJbTVoYldVaU9pSktjM0J5WldGa2MyaGxaWFFpTENKa1lYUmxJam94TnpVM01ETXhNVGN4TENKa2IyMWhhVzRpT2xzaWFuTndjbVZoWkhOb1pXVjBMbU52YlNJc0ltTnZaR1Z6WVc1a1ltOTRMbWx2SWl3aWFuTm9aV3hzTG01bGRDSXNJbU56WWk1aGNIQWlMQ0p6ZEdGamEySnNhWFI2TG1sdklpd2lkMlZpWTI5dWRHRnBibVZ5TG1sdklpd2lkMlZpSWl3aWJHOWpZV3hvYjNOMElsMHNJbkJzWVc0aU9pSXpOQ0lzSW5OamIzQmxJanBiSW5ZM0lpd2lkamdpTENKMk9TSXNJbll4TUNJc0luWXhNU0lzSW1Ob1lYSjBjeUlzSW1admNtMXpJaXdpWm05eWJYVnNZU0lzSW5CaGNuTmxjaUlzSW5KbGJtUmxjaUlzSW1OdmJXMWxiblJ6SWl3aWFXMXdiM0owWlhJaUxDSmlZWElpTENKMllXeHBaR0YwYVc5dWN5SXNJbk5sWVhKamFDSXNJbkJ5YVc1MElpd2ljMmhsWlhSeklpd2lZMnhwWlc1MElpd2ljMlZ5ZG1WeUlpd2ljMmhoY0dWeklpd2labTl5YldGMElsMHNJbVJsYlc4aU9uUnlkV1Y5');

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

export default {
    components: {
        Spreadsheet,
        Worksheet,
    },
    data() {
        // Worksheet data
        const data = [
    [
        "Amount",
        "Thai Baht Text"
    ],
    [
        1234.56,
        "=BAHTTEXT(A2)"
    ],
    [
        5000,
        "=BAHTTEXT(A3)"
    ],
    [
        250.75,
        "=BAHTTEXT(A4)"
    ],
    [
        10000,
        "=BAHTTEXT(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('NWFhZjZiNWQwMmExODA2YWQwMTllNDYyMzkxNDRiYjdhZGYyN2ZiMGY3ZWVlYmVjNGZjODhhM2RkODFiOWUwMzMwNjkwN2IzYTJjNjZmZTFkMzQyNGExZjNhZTdjMWRhOGU2Y2I5YzYzMWRmMzA4ZTliMzU1NzZiY2EzNWM5MjAsZXlKamJHbGxiblJKWkNJNklpSXNJbTVoYldVaU9pSktjM0J5WldGa2MyaGxaWFFpTENKa1lYUmxJam94TnpVM01ETXhNVGN4TENKa2IyMWhhVzRpT2xzaWFuTndjbVZoWkhOb1pXVjBMbU52YlNJc0ltTnZaR1Z6WVc1a1ltOTRMbWx2SWl3aWFuTm9aV3hzTG01bGRDSXNJbU56WWk1aGNIQWlMQ0p6ZEdGamEySnNhWFI2TG1sdklpd2lkMlZpWTI5dWRHRnBibVZ5TG1sdklpd2lkMlZpSWl3aWJHOWpZV3hvYjNOMElsMHNJbkJzWVc0aU9pSXpOQ0lzSW5OamIzQmxJanBiSW5ZM0lpd2lkamdpTENKMk9TSXNJbll4TUNJc0luWXhNU0lzSW1Ob1lYSjBjeUlzSW1admNtMXpJaXdpWm05eWJYVnNZU0lzSW5CaGNuTmxjaUlzSW5KbGJtUmxjaUlzSW1OdmJXMWxiblJ6SWl3aWFXMXdiM0owWlhJaUxDSmlZWElpTENKMllXeHBaR0YwYVc5dWN5SXNJbk5sWVhKamFDSXNJbkJ5YVc1MElpd2ljMmhsWlhSeklpd2lZMnhwWlc1MElpd2ljMlZ5ZG1WeUlpd2ljMmhoY0dWeklpd2labTl5YldGMElsMHNJbVJsYlc4aU9uUnlkV1Y5');

// 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: [
    [
        "Amount",
        "Thai Baht Text"
    ],
    [
        1234.56,
        "=BAHTTEXT(A2)"
    ],
    [
        5000,
        "=BAHTTEXT(A3)"
    ],
    [
        250.75,
        "=BAHTTEXT(A4)"
    ],
    [
        10000,
        "=BAHTTEXT(A5)"
    ]
]
            }]
        });
    }
}