海霸王年菜2016 , 台酒年菜2016 , 外帶年菜2016 , 飯店年菜2016 , 素食年菜2016 , 高雄年菜2016 , 阿霞飯店年菜2016 (年菜菜單)2016年菜預購 高雄年菜餐廳 ... 2016

請問如何用EXCEL，A欄中空白或零及文字計算不要顯示#DIV/0!;#VALUE!

B1是常數；A欄是數值有可能是空白或零及文字；要計算B欄
例:B2=FIXED(($B$1/A2),3)；B3,B4...同B2方式計算

最右側的B值是我想得到的結果.......是代表空白格

-------------- A----------- B --------------- B

1------------.......--------- 100---------------100 ---------
2------------- 5-----------20.000----------20.000 --------
3 ------------ 10---------10.000-----------10.000 ---------
4 -----------........-------- #DIV/0!----------............--------
5------------........-------- #DIV/0!---------.............---------
6------------ 0 ----------- #DIV/0!--------..............---------
7------------..A..----------- #VALUE!------.............--------
8----------- 12-------------8.333-----------8.333-----------

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:

• Massacres That Matter - Part 1 - 'Responsibility To Protect' In Egypt, Libya And Syria
• Massacres That Matter - Part 2 - The Media Response On Egypt, Libya And Syria
• National demonstration: No attack on Syria - Saturday 31 August, 12 noon, Temple Place, London, UK