Blogtrottr
Yahoo!奇摩知識+ - 分類問答 - 電腦網路 - 發問中
Yahoo!奇摩知識+ - 分類問答 - 電腦網路 - 發問中 
Dog-Lovers' Tees.

Unleash yourself and shop our special collection of tees and accessories for you and your pooch.
From our sponsors
EXCEL~超出範圍&計算出超出多少
Sep 8th 2014, 11:57

各位大大

一表單如下：

------A---------B----------C--------D---------E
1--標準值--上公差----下公差---量測值---差距
2----125------0.5-------0.3------125.7-----0.2
3

假設E2原先無數值

所以若想設定E2格內可判讀D2量測值是否有大於或小於A2±B2orC2標準值±公差

一但大於或小於標準值±公差，即可於E2格內顯示出超出或低於多少

就像例中D2125.7大於A2+B2(125.5)之值0.2，E2即顯示0.2

請問這個條件如何設定，謝謝。

備註："----"為了排版用，無特別涵義

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

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

    E-mail轉寄