TEXT Function: 7 Major Uses

It may seem inconspicuous, but the TEXT function can play a significant role. This time we specifically point out seven major uses of the TEXT function.
看似毫不起眼，卻能起到大作用的TEXT函數，大家要認真學學。今次特別指出了TEXT函數7大功用。

The basic syntax is:
基本語句是：

=TEXT(value to be processed, “format code to be used”)
=TEXT(要處理的數據,”要使用的格式代碼”)

1. Add a dollar sign to amounts
   為金額加上符號$：=TEXT(D2,”$0元”)
   

   ---

2. Convert date formats
   轉換日期格式：=TEXT(C2,”e年mm月dd日 aaaa”)
   

   ---

3. Simple employee evaluation
   簡單的員工考評：=TEXT(D2-500,”超額0元;還差0元;剛好”)
   

   ---

   ---

4. Convert amounts to uppercase
   金額變成大寫：=TEXT(D2,”[DBNum2]0元”)
   

   ---

5. Calculate hours
   計算小時數：=TEXT(D2-C2,”[h]”)
   

   ---

6. Concatenate text and percentages
   連接文字和百分比：=”已完成”&TEXT(A2,”0%”)
   

   ---

7. Simplify formula judgments
   簡化公式判斷：=TEXT(C2-B2,”比上年多0元;比上年少0元;與上年相同”)