Combine two if then statements into or statement

[Guest]

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.

 

[Frank Kabel]

Hi
use
=IF(AND(A15=TRUE,A8=TRUE),C60+C61+C62+C74,IF(A18=TRUE,C63+C64+C65+C71+C
78+C79+C81,0))

 

[bigwheel]

Try the formula without the OR

i.e.
=IF(AND(A15=TRUE,A8=TRUE),(C60+C61+C62+C74),IF(A18=TRUE,(C63+C64+C65+C71+C78
+C79+C81),0))