EXCEL~超出範圍&計算出超出多少:Realtime－ 2015年假公告, 2015年假幾天, 2015年假公告人事行政局, 2015年假放幾天, 2015行事曆, 2015 國定假日, 2015年假日期, 2015年假9天, 明年假期2015, 2015 年假,

Blogtrottr

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

Explore DIRECTV

Enjoy HD DVR service in every room. Get every game every Sunday. Watch hit movies and shows anywhere. Bundle and save today!

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