Sum positive and negative values

[Nutzman]

Hi all,

I have a scenario, where I need to sum 2 values.
In the first scenario I have a Negative and a positive value. The result I seek is to change the negative to a positive and sum the 2 values.
In the second scenario, I have a positive and a positive value. I need to deduct the first value from the second.

I attach a spreadsheet, with values and the results I seek.

Thanking you all in advance.

Nutzman

[Mazzaropi]

Nutzman, Good morning.

You can use the same formula for both cases.

Try to use:

B5 --> =(B3*-1)+B4

C5 --> =(C3*-1)+C4

Please, tell us if it worked as you need.

I hope it helps.

[sandy666]

or
1st: =SUM(ABS(B3),B4) or =SUM(-B3,B4)
2nd: =SUM(-C3,C4)

[Nutzman]

To quick!!! Thank you for the formula. Now i can continue with my project.

[sandy666]

If that takes care of your original question, & to say Thanks, please click on Add Reputtion (bottom left corner of the post of the person(s) who helped you)

If you did it already - ignore it.
Thank you.