If/And Statement with Multiple Cells

[Legacy 48831]

Hello Everyone. I am having a very difficult time with an If Statement. It has been a very long time since I have done this so I am a bit rusty.
The calculation consists of the following, Cell H12 has the calculation/function, Cell C12 needs to be greater than Zero, and cell M5 needs to also be greater than Zero. If this is true then the result in H12 should be J12 + M6. Also, if cell C12 is greater than Zero, and cell M5 is less than zero, then the result in H12 would be J12 - M6. Otherwise if cell C12 equals zero then cell H12 needs to result in zero.
Could someone please point me in the right direction?

 

[philwojo]

Try this in H12:

=IF(AND(C12>0,M5>0),(J12+M6),IF(AND(C12>0,M5<0),(J12-M6),0))

 

[Scott Huish]

=if(c12>0,j12+(m6*sign(m5)),0)

 

[Legacy 48831]

Try this in H12:

=IF(AND(C12>0,M5>0),(J12+M6),IF(AND(C12>0,M5<0),(J12-M6),0))

Thank you philwojo. Your solution worked perfectly. I spent several hours and could not wrap my mind around the solution so I thought I would check with those on the forums with more knowledge than myself, glad I did!!

 

[philwojo]

Glad it worked, there are probably better ways to do it but i'm still learning as well.