How do logicals be added or multiplied?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

dindigul - 23 Apr 2007 23:49 GMT

Hello
The following does work, but how is the question.
=SUMPRODUCT((range_a < c3)*(range_b>=c9))
When input individually i.e. =(range_a<c3) produces either TRUE or FALSE and
same thing for =(range_b>=c9). But as a whole it does produce values like
1,2 ... What is happening? Any ideas?
Thanks

Reply to this Message

AKphidelt - 24 Apr 2007 00:54 GMT

Because the the formula is saying when using an *

How many times is this event TRUE...

So in your formula it just counts up the number of times range_a is less
then c3 and range b> c9

So since it's just referring to one combination, if both values are true...
it will add it up to 1. If one of the arguments is false, it will be 0.

When you just do range_b > c9 its just saying... is it or is it not TRUE

> Hello
> The following does work, but how is the question.
[quoted text clipped - 3 lines]
> 1,2 ... What is happening? Any ideas?
> Thanks

Reply to this Message

Stan Brown - 24 Apr 2007 00:57 GMT

Tue, 24 Apr 2007 04:19:34 +0530 from dindigul <padhye.m@gmail.com>:

> Hello
> The following does work, but how is the question.
> =SUMPRODUCT((range_a < c3)*(range_b>=c9))
> When input individually i.e. =(range_a<c3) produces either TRUE or FALSE and
> same thing for =(range_b>=c9). But as a whole it does produce values like
> 1,2 ... What is happening? Any ideas?

TRUE translates to 1, and FALSE to 0.

For much, much more:
http://www.xldynamic.com/source/xld.SUMPRODUCT.html

Signature

Stan Brown, Oak Road Systems, Tompkins County, New York, USA
http://OakRoadSystems.com/

Reply to this Message

Rate this thread: