Documentation/Calc Functions/BAHTTEXT

    From The Document Foundation Wiki


    Function name:

    BAHTTEXT

    Category:

    Text

    Summary:

    Converts a number representing an amount of Thai currency into Thai text, including currency names. The baht is the official currency of Thailand and a baht is subdivided into 100 satang.

    Syntax:

    BAHTTEXT(Number)

    Returns:

    Returns a string that expresses the given amount in Thai text, including currency names.

    Arguments:

    Number is a real number, or a reference to a cell containing a real number, that contains the amount to be converted. The integer part of Number is the number of baht and the fractional part gives the number of satang. For example, 12.34 corresponds to 12 baht and 34 satang. Number may be positive or negative.

    • If Number is non-numeric, then BAHTTEXT reports a #VALUE! error.
    • The fractional part of Number is rounded to the nearest satang.

    Additional details:

    None.

    Examples:

    Formula Description Returns
    =BAHTTEXT(1) Here the function converts the value 1 to Thai text, returning a string that translates to English as "One baht". หนึ่งบาทถ้วน
    =BAHTTEXT(G1) where cell G1 contains the number 1.758. Here the function converts the value 1.758 to Thai text, returning a string that translates to English as "One baht and seventy-six satang". Note that the fractional part of the argument has been rounded to give 76 satang. หนึ่งบาทเจ็ดสิบหกสตางค์
    =BAHTTEXT(−2.5) Here the function converts the value -2.5 to Thai text, returning a string that translates to English as "Minus one baht and fifty satang". ลบหนึ่งบาทห้าสิบสตางค์

    Related LibreOffice functions:

    None.

    ODF standard:

    None.

    Related (or similar) Excel functions:

    BAHTTEXT