Not Returning a Negative

[nsnodgrass73]

I have this formula:

=IFERROR(IF(OR(O28<0,P28<0),O28+P28,""),"")

Where as O28 is -$2165.80 and P28 is $14195.00 and Q28 returns $12029.30. This needs to return -$12029.30.

I have also tried:

=IFERROR(IF(O28<0, O28+P28,IF(O28>0,O28-P27,0)),0)

neither are returning a negative number. I have formatted the cells Number >> (-2165.80)

I need the formula to look and see if O is a positive or negative and then do the math correctly with P (is always positive) resulting in Q.

 

[6StringJazzer]

This needs to return -$12029.30.

That contradicts the logic in your formula; formula says it should return the null string.

P (is always positive)

If P is always positive, why are you checking it in the first formula?

Can you explain the logic of why you want to get the opposite of the correct sign as the result of adding numbers? I really cannot imagine any real-world reason to do this. It might help to explain your reasoning.

But if you want the negative of the correct result if O<0, then

=(P28+O28)*IF(O28<0,-1,1)

 

[nsnodgrass73]

That contradicts the logic in your formula; formula says it should return the null string.


If P is always positive, why are you checking it in the first formula?

Can you explain the logic of why you want to get the opposite of the correct sign as the result of adding numbers? I really cannot imagine any real-world reason to do this. It might help to explain your reasoning.

But if you want the negative of the correct result if O<0, then

=(P28+O28)*IF(O28<0,-1,1)

Thank you. That's what I needed.