CSE Formula
 

In creating a CSE formula the asterisk is used for AND... for example:
sum(if((Code="test")*(Acct="Recon"),Amount)), where Code, Acct and Amount
are ranges.

What sign is used for OR? What I'm trying to do is sum the values in the
"Amount" range if Code="test" OR Code="live" AND Acct="Recon"

Thanks,

gregory

CSE Formula
 

try
code={"test","live"}

--
Don Guillett
SalesAid Software

"gregory" wrote in message
...
In creating a CSE formula the asterisk is used for AND... for example:
sum(if((Code="test")*(Acct="Recon"),Amount)), where Code, Acct and Amount
are ranges.

What sign is used for OR? What I'm trying to do is sum the values in the
"Amount" range if Code="test" OR Code="live" AND Acct="Recon"

Thanks,

gregory

CSE Formula
 

Don,

Thank you very much. This worked!!

gregory

"Don Guillett" wrote:

try
code={"test","live"}

--
Don Guillett
SalesAid Software

"gregory" wrote in message
...
In creating a CSE formula the asterisk is used for AND... for example:
sum(if((Code="test")*(Acct="Recon"),Amount)), where Code, Acct and Amount
are ranges.

What sign is used for OR? What I'm trying to do is sum the values in the
"Amount" range if Code="test" OR Code="live" AND Acct="Recon"

Thanks,

gregory

CSE Formula
 

the asterisk is actually "times" and not "and"
you have two true/false statementss with values 0 or 1
try
=sum(if(and(or(Code="test",Code="live"),Acct="Reco n"),Amount)

"gregory" wrote:

In creating a CSE formula the asterisk is used for AND... for example:
sum(if((Code="test")*(Acct="Recon"),Amount)), where Code, Acct and Amount
are ranges.

What sign is used for OR? What I'm trying to do is sum the values in the
"Amount" range if Code="test" OR Code="live" AND Acct="Recon"

Thanks,

gregory

CSE Formula
 

glad to help

--
Don Guillett
SalesAid Software

"gregory" wrote in message
...
Don,

Thank you very much. This worked!!

gregory

"Don Guillett" wrote:

try
code={"test","live"}

--
Don Guillett
SalesAid Software

"gregory" wrote in message
...
In creating a CSE formula the asterisk is used for AND... for example:
sum(if((Code="test")*(Acct="Recon"),Amount)), where Code, Acct and
Amount
are ranges.

What sign is used for OR? What I'm trying to do is sum the values in
the
"Amount" range if Code="test" OR Code="live" AND Acct="Recon"

Thanks,

gregory