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