Thread
:
CSE Formula
View Single Post
#
3
Posted to microsoft.public.excel.worksheet.functions
gregory
Posts: n/a
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
Reply With Quote