combing statements - tried question but it kept erroring out on me

[Guest]

Here is the first:
=IF(AND(A15=TRUE,A8=TRUE),(C60+C61+C62+C74),0)

Here is the second:
=IF(A18=TRUE,(C63+C64+C65+C71+C78+C79+C81),0)

I need these to work together in one cell. However when I tried using OR it
doesn't want to work properly. This is what I came up with (actually I
believe Excel did the auto-correct as well to it):
=IF(OR(AND(A15=TRUE,A8=TRUE),(C60+C61+C62+C74),0),
IF(A18=TRUE,(C63+C64+C65+C71+C78+C79+C81),0))

Any help is greatly appreciated.

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
see your other post

 

[Jim]

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

This is corerect i guess!