excel函數 PRODUCT用法

A1 = 1

B1 要設了 =PRODUCT(a1,4.5)

但如果我a1為0時 b1就會代出 5

當a1沒資料or資料為0時 要怎麼讓b1的公式代出來為0?

4 Answers

Rating
  • 老夥
    Lv 7
    9 years ago
    Favorite Answer

    =IF(OR(A1="",A1=0),0,PRODUCT(A1,4.5))

    2011-09-15 11:25:10 補充:

    =(A1>0)*PRODUCT(A1,4.5)也可以

    2011-09-15 14:47:48 補充:

    =IF(OR(A1="",A1=0),0,PRODUCT(A1,4.5)) 或

    =(A1>0)*PRODUCT(A1,4.5)也可以。

  • Anonymous
    9 years ago

    =A1*4.5

    不行嗎 ?

  • 9 years ago

    =IF(OR(A1="",A1=0),0,PRODUCT(A1,4.5)) 這個成功了!! 感謝唷

  • sherri
    Lv 6
    9 years ago

    =IF(A1>0,PRODUCT(A1,4.5),0)

    Source(s): Me
Still have questions? Get your answers by asking now.