IF I4 is positive than i want to subtract I4-J4 but if I4 is negative than add I4+J4

[PhilipeC]

IF I4 is positive than i want to subtract I4-J4 but if I4 is negative than add I4+J4?

 

[Rick Rothstein]

IF I4 is positive than i want to subtract I4-J4 but if I4 is negative than add I4+J4?

You did not say what should happen if I4 equal 0, but give this a try...

=IF(I4>0,I4-J4,I4+J4)

 

[PhilipeC]

The formula is adding when there a positive number in I4 but when there a negative number, it still adding instead of subtracting.

 

[Rick Rothstein]

The formula is adding when there a positive number in I4 but when there a negative number, it still adding instead of subtracting.

What should the result be for each of the following values...
[table="width: 500"]
[tr]
[td]I4[/td]
[td]J4[/td]
[td]Result[/td]
[/tr]
[tr]
[td]100[/td]
[td]50[/td]
[td][/td]
[/tr]
[tr]
[td]0[/td]
[td]50[/td]
[td][/td]
[/tr]
[tr]
[td]-100[/td]
[td]50[/td]
[td][/td]
[/tr]
[/table]

 

[PhilipeC]

I4----J4 Result

100---50 -----> 100 - 50 = 50

0---50 ---> 0 + 50 = 50

-100---50 ---> - 100 - 50 = -150

 

[Scott Huish]

=i4+odd(sign(i4))*j4

 

[Rick Rothstein]

I4----J4 Result

100---50 -----> 100 - 50 = 50

0---50 ---> 0 + 50 = 50

-100---50 ---> - 100 - 50 = -150

J4 is +50 for each scenario that I asked about. Your thread title say...

"but if I4 is negative than add I4+J4"

Why do you show -100 - 50 when your thread title show +J4 for this condition?

 

[PhilipeC]

Yes, Sorry about that , my answer was badly written. The previous formula had worked, Thank you

 

[Rick Rothstein]

The previous formula had worked, Thank you

Which previous formula... the one from Message #2 or the one from Message #6 ?

 

[PhilipeC]

Formula from question #2