[請問] excel的問題:－2014星座運勢大預言, 唐立淇2014星座運勢, 2014星座運勢處女座, 2014星座運勢雙魚座, 2014星座運勢天秤座, 薇薇安2014星座運勢

Blogtrottr

批踢踢實業坊 ask 板

Protect Yourself & Family

Never walk alone again with MyForce personal security you keep on your smartphone. Our 5-Diamond CSAA Monitoring Agents instantly monitor all alerts 24/7 nationwide.

From our sponsors

[請問] excel的問題

Aug 8th 2013, 14:18, by lance7483

作者lance7483 (lance)

看板ask

標題[請問] excel的問題

時間Thu Aug 8 14:18:10 2013

各位板友好：我用的是excel 2003版的我好不容易解決了要將儲存格中若相乘為整數，則出現整數沒有小數點的情形如果相乘有小數，則出現小數→圖示如下單價數量總價 a 1.1 10 11 b 1.1 9 9.9 小計 20.9 運用=IF(TRUNC(a1*$a2)=a1*a2,TEXT(a1*$a2,"#,##0"), TEXT(a1*$a2,"#,##0.##")) 用這個公式就可以在總價裡出現我所要的形情了但問題又發生了，因為公式裡面含有文字的形態所以在小計的那一個欄位要加總的時候結果就會呈現"0" 但是如果我用手動的方式加總也就是 = a1+b1 會出現20卻不會出現 20.9的結果並且我要符合如果加總是整數則不出現小數點的狀態麻煩大家了…謝謝 -- ※ 發信站: 批踢踢實業坊(ptt.cc) ◆ From: 60.251.191.31

This entry passed through the Full-Text RSS service — if this is your content and you're reading it on someone else's site, please read the FAQ at fivefilters.org/content-only/faq.php#publishers. Five Filters recommends: 'You Say What You Like, Because They Like What You Say' - http://www.medialens.org/index.php/alerts/alert-archive/alerts-2013/731-you-say-what-you-like-because-they-like-what-you-say.html

You are receiving this email because you subscribed to this feed at blogtrottr.com.

If you no longer wish to receive these emails, you can unsubscribe from this feed, or manage all your subscriptions