If calculation to only count either positive or negative volumes

[Woofy_McWoof_Woof]

Hi. I'm trying to create a formula for cells D2 and E2 that looks at the original position less the change but only if it impacts the positive or negative side of zero accordingly. For instance, in the example below the original starting position was positive 10 but due to a change of negative 25 the new position is now negative 15. I would like to show the split of the negative 25 to show negative 10 affects the positive side only and the negative 15 affects the negative side only. The formula should also be reversible in case the example is the opposite way round. Thanks very much in advance for your help with this, its been driving me mad.

	A	B	C	D	E
1	Original export	Original import	Change	Export change	Import change
2	10	0	-25	-10	-15

 

[jtakw]

The formula should also be reversible in case the example is the opposite way round.

Can you show a couple more samples with expected results illustrating what you mean, especially regarding Bold quoted above?