Plus and minus into 2 columns.

[serge]

Hi everyone,

I'm looking for 2 formulas one that will calculate the minus in column C and the plus in column D.

In column A3 and going down, I've got numbers, starting in A3: 1 in A4:10 then 27, 5 36 39 15 8 and so on, what I need in cell D4 is the difference between those 2 numbers in A3 and A4, here it will be 9 in cell D4 then 17 in cell D5 then 22 in cell C6 and 31 in cell D7, and so on.

Would someone have and idea about those 2 formulas ? Thank you.

Serge.

 

[jmacleary]

Hi there, if I understand correctly, you want positive differences in column D and negative differences in column C. If so, here are the 2 formulas you need:
In C4 put =IF(A4< A3,A3-A4,"")
in D4 put =IF(A4>A3,A4-A3,"")
and then drag down the 2 columns.

 

[Peter_SSs]

I'm assuming that you also need to allow for two equal cells to occur so I have included that result in column C.
Each formula copied down.

Excel Workbook
	A	B	C	D
3	1
4	10		9
5	27		17
6	5			22
7	36		31
8	39		3
9	15			24
10	8			7
11	8		0
12	15		7
Plus Minus

@jmacleary
If you use a < followed immediately by a letter, you need to add a space between them or else the forum interprets that as HTML code & your formula gets chopped off.
I've fixed it for you.

 

[serge]

Thanks to both of you that's exactly what I was looking for, thank you Peter for the extra thought.
Serge.

 

[Peter_SSs]

Thanks to both of you that's exactly what I was looking for, thank you Peter for the extra thought.
Serge.

You're welcome.