combining Formulas

[nicolette]

OK so I have the following formulas that i'm trying to figure out how to combine so that the results of one or the other are output. Thanks!

IF(AND(D7>0,P7>0),D7+P7,D7)

IF(AND(D7>0,V7>0),D7-V7,V7)

 

[Ganjin]

would this formula:
IF(AND(D7>0,P7>0),D7+P7,D7)
only apply if V7<=0?

if so, then this should achieve what you want:
IF(V7<=0,IF(AND(D7>0,P7>0),D7+P7,D7),IF(D7>0,D7-V7,V7))

 

[nicolette]

Nevermind I think I figured it out!

 

[nicolette]

would this formula:
IF(AND(D7>0,P7>0),D7+P7,D7)
only apply if V7<=0?

if so, then this should achieve what you want:
IF(V7<=0,IF(AND(D7>0,P7>0),D7+P7,D7),IF(D7>0,D7-V7,V7))

Thanks, This is what I ended up doing
IF(AND($D7>0,$P7>0),$D7+$P7,(IF(AND($J7=0,$P7=0,$V7=0),$D7,0)))+(IF(AND($D7>0,$V7>0),$D7-$V7,(IF(AND($D7=0,$P7=0,$V7=0),$V7,0))))

Probably the long way around, but with testing thus far all calculations are seeming to come out correct...