« Home | MSN的撞球遊戲---Bankshot Billiards Deluxe (單機版) » | RM to AVI MPEG WMV VCD SVCD DVD Converter 1.3 繁體中文... » | gmail邀請信集中營 » | NERO RECODE 包含於 NeroVisionExpress » | McAfee Desktop Firewall 8.0 繁體中文版 » | 超級兔子魔法設定 Super Rabbit Magic Set V6.15 繁體中文版 » | 14個步驟完美備份DVD9轉DVD5並燒錄 » | 如何使用WORD儲存備份檔? » | 新增移除程式中的項目無法刪除? » | F-Secure5.52+中文化 » 

Monday, September 20, 2004 

在Excel中,如何設定在儲存格中,出現「文字+公式計算結果」?

如果希望在儲存格中,出現「文字+公式計算結果」,例如:總計60人(其中的60為公式計算結果),可以依照下面的兩個方法的步驟完成:

方法一:

請在該儲存格內輸入「="總共"& 公式 & "人"」,也就是說如果要在公式前插入文字,就在公式前加上「"要插入的文字" &」。

方法二:

先選取適當儲存格,→「格式」→「儲存格」→「數字」→「自訂」,再視需要在「類型」框內鍵入「"總共"?"人"」或「"平均"?"人"」或「"最大數是 "?」等等,按「確定」。然後利用插入函數方式取得該儲存格所需的數值,所獲得的答案便是文字連同依據公式算出的數值。這種方式較麻煩,但它的優點是公式可用插入函數方式輸入,不必使用鍵盤。

Wonderful and informative web site. I used information from that site its great. »

Three passions,warcraft leveling simple but wow lvl overwhelmingly strong,wow power level have governed wow power level my life: the longing wrath of the lich king power leveling for love, the search for knowledge,World of warcraft Power Leveling and unbearable pity WOTLK Power Leveling for the suffering wlk power leveling of mankind. These passions,wlk power leveling like great winds,age of conan gold have blown me hither and thither,cheap aoc gold in a wayward course,aoc power leveling over a great ocean ffxi gil of anguish, reaching final fantasy xi gil to the very verge of despair. I have sought love, first, because it brings ecstasy - ecstasy so great that I would often have sacrificed FFXI Gil all the rest of life for final fantasy gil a few hours of this joy. I have sought it, wow gold because it relieves loneliness--that terrible loneliness in which one shivering consciousness dog clothes looks over the rim of the world into the cold unfathomable lifeless abyss.

[url=http://certifiedpharmacy.co.uk/products/altace.htm][img]http://onlinemedistore.com/3.jpg[/img][/url]
on line pet pharmacy http://certifiedpharmacy.co.uk/products/trazodone.htm blythewood pharmacy [url=http://certifiedpharmacy.co.uk/products/bactroban.htm]definition of pharmacy and therapeutics committee[/url]
specialty pharmacy manager job jobs http://certifiedpharmacy.co.uk/products/plavix.htm cvs pharmacy brooklyn [url=http://certifiedpharmacy.co.uk/products/nimotop.htm]nimotop[/url]
nrop online pharmacy discussion forum http://certifiedpharmacy.co.uk/products/bystolic.htm renewal certified pharmacy technician license [url=http://certifiedpharmacy.co.uk/products/zantac.htm]ferris state pharmacy[/url]
supplemental pharmacy insurance http://certifiedpharmacy.co.uk/products/rogaine-5-.htm the board of pharmacy protects [url=http://certifiedpharmacy.co.uk/products/zithromax.htm]zithromax[/url]

Post a Comment