Why is PRODUCT function yielding 0 when multiplying two Boolean cells?

[bisel]

This is crazy.

I am using Boolean logic to in cells L5 through L14. They are all "TRUE"

If I multiply each of those cells together using the formula, =L5*L6*L7*L8*L9*L10*L11*L12*L13*L14, the result is 1. However if I use the Excel function, = PRODUCT(L5:L14), the result is 0.

Does anyone have an explanation for this?

​

Thanks,

Steve

 

[Joe4]

Apparently, the SUM and PRODUCT functions ignore Boolean values.
However, you can coerce them to numbers to get them to work like this:

=PRODUCT(--L5:L14)

 

[Eric W]

If you know they are all Boolean values, why not use the Boolean function AND?

 

[Scott Huish]

and if you want the 1 or 0
=--AND(L5:L14)

 

[bisel]

Apparently, the SUM and PRODUCT functions ignore Boolean values.
However, you can coerce them to numbers to get them to work like this:

=PRODUCT(--L5:L14)

Your solution works nicely. Thank you. But I marked the solution to use the Boolean function AND instead and it works as well.

 

[Peter_SSs]

Does anyone have an explanation for this?

To answer your actual question from your thread title ..

Why is PRODUCT function yielding 0 when multiplying two Boolean cells?

From the Help for the PRODUCT function:

The PRODUCT function multiplies all the numbers given as arguments and returns the product.

In your example there are no numbers as arguments, only Boolean values.