3 ms·
I was particularly impressed by this detail further down the conversation: Let A1 = 1, A2 = blank, A3 = 3 PRODUCT(A1:A3) is 1 A1 * A2 * A3 is 0
by asuffield 12y ago
I was particularly impressed by this detail further down the conversation:
Let A1 = 1, A2 = blank, A3 = 3
PRODUCT(A1:A3) is 1
A1 * A2 * A3 is 0
- lifeisstillgood 12y agoWell that's just inconsistent and annoying and wrong. I think the original comments are still over the top, as it seems to be arguin that a defined convention exists but the OP disagreed with it. However if your example is what they were actually complaining about then hell yes.
- endersshadow 12y agoWithin Excel, ranges ignore blank cells in computation, but a reference to a blank cell returns 0. The idea being that if you specify a cell in a computation, you're expecting something to be there, whereas when you have a range, you may have sparse data throughout that range, and therefore, the result shouldn't break. SQL behaves similarly. See: http://www.sqlfiddle.com/#!15/37025/5 http://www.sqlfiddle.com/#!15/37025/5
- JadeNB 12y ago> Let A1 = 1, A2 = blank, A3 = 3 > PRODUCT(A1:A3) is 1 3, I think (based on experimentation).