close
Blogtrottr
Yahoo!奇摩知識+ - 分類問答 - 電腦網路 - 發問中
Yahoo!奇摩知識+ - 分類問答 - 電腦網路 - 發問中 
Eventbrite makes it happen

Create an event and sell tickets online through Eventbrite. It's simple! Sign up and get started today.
From our sponsors
Excel if無輸入時 為空白時 如何寫公式問題
Aug 13th 2013, 15:05

因為在做表格的時候 都是下拉整個表格 但還沒輸入時

表格內都會出現#N/A 可以麻煩大大運用下面的公式 在套入假設無輸入資訊時

會出現空白的資訊嗎? 謝謝大大

=IF(MOD(M3,P3)=0,INT(M3/P3),(INT(M3/P3)&"."&MOD(M3,P3)))

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
arrow
arrow
    全站熱搜
    創作者介紹
    創作者 miokoks 的頭像
    miokoks

    線上遊戲排行榜2013/2014,進擊的巨人線上看,candy crush saga外掛,正妹寫真三圍

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

    E-mail轉寄