Thursday 10 July 2014

Excel Bahttext Function

Microsoft Excel Bahttext Function

Basic Description

The Excel Bahttext function converts a number into Thai text, with the the suffix "Baht".
The syntax of the function is :
BAHTTEXT( number )
Where the number argument can be supplied to the function either directly, or as a reference to a cell containing a number.

Bahttext Function Examples

The following spreadsheet shows two simple examples of the Excel Bahttext function. The format of the function is shown in the spreadsheet on the left and the result is shown in the spreadsheet on the right.
 Formulas:
Examples of use of the Excel Bahttext Function
 Results:

 

Bahttext Function Error

If you get an error from the Excel Bahttext function, this is likely to be the #VALUE! error :

#VALUE!-Occurs if the supplied number argument is not recognised as a numeric value.

No comments:

Post a Comment