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

M

M

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.
 
J

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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top