Re: Combine two if then statements into or statement
From: Frank Kabel (frank.kabel_at_freenet.de)
Date: 10/22/04
- Next message: Frank Kabel: "Re: combing statements - tried question but it kept erroring out on me"
- Previous message: bigwheel: "Re: Combine two if then statements into or statement"
- In reply to: M: "Combine two if then statements into or statement"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 22 Oct 2004 22:27:06 +0200
Hi
use
=IF(AND(A15=TRUE,A8=TRUE),C60+C61+C62+C74,IF(A18=TRUE,C63+C64+C65+C71+C
78+C79+C81,0))
-- Regards Frank Kabel Frankfurt, Germany "M" <M@discussions.microsoft.com> schrieb im Newsbeitrag news:0ACB745A-D3A0-4522-A0C0-4172654C5D5E@microsoft.com... > This is statement one: > > =IF(AND(A15=TRUE,A8=TRUE),(C60+C61+C62+C74),0) > > This is statement two: > > =IF(A18=TRUE,(C63+C64+C65+C71+C78+C79+C81),0) > > I need to combine these so that appropriate value whether zero or one of > those sums are returned depedent on what is true. > > I tried to combine it and ended up with this: > =IF(OR(AND(A15=TRUE,A8=TRUE),(C60+C61+C62+C74),0), > IF(A18=TRUE,(C63+C64+C65+C71+C78+C79+C81),0)) > > But that does work because when A15&A8 are true it comes back zero instead > of adding up the sum of C60,C61,C62,C74. > I am sure its just one tiny thing I am missing or guessing that's all it is > but I just can not seem to find it. I greatly appreciate any help. > > Thanks! > > -- > M > A+ Certified > 8 yrs of IT Experiance in Support/Admin > > VB exp. based on self taught and what others have helped with. > > Very proficient in Office applications as far as functionality.
- Next message: Frank Kabel: "Re: combing statements - tried question but it kept erroring out on me"
- Previous message: bigwheel: "Re: Combine two if then statements into or statement"
- In reply to: M: "Combine two if then statements into or statement"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
