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