Excel Function: BAHTTEXT

Purpose

The BAHTTEXT function translates a number into a text value. The text value expresses the number as a monetary amount in Thailand’s language and currency. “บาท” (Baht) and, if appropriate, “สตางค์” (Satang) are included in the result. For example, “สิบบาทห้าสิบสตางค์” is 10 Baht and 50 Satang.

Arguments

Argument	Argument type	Description
number	Mandatory	A number to be converted into Thai.

Examples

Example	Formula	Result	Description
1	`=BAHTTEXT(0)`	`ศูนย์บาทถ้วน`	Apply the BAHTTEXT function to the number 0. When translated into English the result is “0 Baht“.
2	`=BAHTTEXT(1)`	`หนึ่งบาทถ้วน`	Apply the BAHTTEXT function to the number 1. When translated into English the result is “1 Baht“.
3	`=BAHTTEXT(1.5)`	`หนึ่งบาทห้าสิบสตางค์`	Apply the BAHTTEXT function to the number 1.5. When translated into English the result is “1 Baht and 50 Satang“.
4	`=BAHTTEXT(-1)`	`ลบหนึ่งบาทถ้วน`	Apply the BAHTTEXT function to the number -1. When translated to English the result is “Minus 1 Baht“.
5	`=BAHTTEXT(-1.5)`	`ลบหนึ่งบาทห้าสิบสตางค์`	Apply the BAHTTEXT function to the number -1.5. When translated to English the result is “Minus 1 Baht and 50 Satang“.