Excel 算式中如何設定大於某個數字才可乘上後方數字:－2016韓國代購網 , 韓國代購化妝品 , 韓國代購批發 , 韓國代購教學---韓國代購/追加/寄貨

Blogtrottr

Yahoo!奇摩知識+ - 分類問答 - 電腦網路 - 發問中

Jun 1st 2013, 03:34

各位大大您們好：
我有個算式問題困擾很久，在網上也一直找不到資料
問題就是：

在excel算式中如何設定當大於某個數字才可乘上後方數字
比如說：
如果以10000當基準點(假設這個數字是位於 A1 的位置)
而格式中當數字為超過10000 時，則會設定成 =A1*10%
(此時格式中自動會算出1000 這數字)

而格式中當數字為低於10000 時，則該如何設定成不自動 *10% 呢?

請各位好心的大大幫幫忙吧

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