Possible error in product calculation

Possible error in product calculation

Posted by: otoole on 1 November 2019, 3:23 am EST

• 

  otoole

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 1 November 2019, 3:23 am EST

  I have four cells. The last cell (G1) has a formula:

  "=C1 + PRODUCT(E1,F1)
  

  E1 is a numeric up down, so it always has a whole value of at least one. When F1 is empty, the result in G1 acts as if the value of F1 is 1, so the resulting formula is

  =C1 + PRODUCT(1+1)
  

  When I enter 0 into F1, the resulting formula is

  =C1 + PRODUCT(1+0)
  ``` which seems correct.
  
  Shouldn't a blank in F1 result in a value of 0 instead of 1?

• 

  jitender.yadav

  

  • Post Options:
  • Link
    Copy

  Posted 3 November 2019, 4:42 pm EST

  Hi,

  This is the normal behavior of PRODUCT function. The default value for blank cell is considered as 1 (not 0). This is consistent with Excel’s PRODUCT function.

  Regards,
  
  Jitender