Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.

Excel-乘法函數

請教各位大大

因工作上需求要設計一個表格方便快速運算

我原本使用A2*B2*C2*D2來算乘法,但有時候只有三個數字變成有一格會是0,導致算出來結果是0,想請教各位大大可以怎麼寫讓程式會自動把0跳過,只乘上有數字的格子

我的資料是像這樣打的,有時候是三個數相乘有時式四個數相乘,我通常一個文件有一百多組,導致我需要改來改去,所以想請各位大大幫忙指教一下,謝謝

4 * 5 * 2 * 6

5 * 2 * 3

7 * 8 * 9 * 5

4 * 7 * 2

2 Answers

Rating
  • lmf
    Lv 5
    8 years ago
    Favorite Answer

      A B C D E F G H 1 4 * 5 * 2 * 6 240 2 5 * 2 * 3     30 3 7 * 8 * 9 * 5 2,520 4 4 * 7 * 2     56 5 5 * 2 * 3 * A 30 6 6 * 3 * 4 * 0 0 H1公式: =PRODUCT(A1:G1) 下拉複製 (會自動跳過文字及符號, 除非輸入0才會呈現答案為0)

  • 8 years ago

    嗯!!!!!!!!!!!!!!!!!!!!!!!

Still have questions? Get your answers by asking now.