Blogtrottr
Yahoo!奇摩知識+ - 分類問答 - 電腦網路 - 已解決
Yahoo!奇摩知識+ - 分類問答 - 電腦網路 - 已解決 
The Best Way to Manage your Money.

Start using Mint today to set a budget, track your goals and do more with your money.
From our sponsors
請教EXCEL算式裡關於$的意思?
Dec 16th 2013, 03:33

LOG( number , base )
是對數函數的表示方式，number是所要處理的正實數，base是計算對數所用的基底，如省略不填則為10。

以版大的例子:
=LOG(E10/$G$8,2)

可說是計算 E10/$G$8 這個結果，是2的幾次方，假設:
E10/$G$8 = 4 ，則 LOG(E10/$G$8,2) = 2
E10/$G$8 = 8 ，則 LOG(E10/$G$8,2) = 3

因此，回推來說，若公式再加上2為底，即:
=2^LOG(E10/$G$8,2)
結果即等於 E10/$G$8 這個結果的值

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.
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
arrow
arrow
    全站熱搜

    jmuko99 發表在 痞客邦 留言(0) 人氣()

    E-mail轉寄