Various Cells Increasing/Decreasing

[NoahsArc]

Hi,

I have a data set here with a list of people who made % changes on specific dates (the % change is not what they increased/decreased by, it is what they changed to). I'm trying to figure out a way to take the first value and then show any subsequent movement. Some people increased and then decreased and then increased again, I need to see that listed plainly and be able to sort by this criteria.

So for example:

John 3% 5% 2%

I'd like a statement to show if he increased, decreased, or increased then decreased.

Any help would be appreciated!
Noah

 

[Jamie McMillan]

Hello,

I put 'John's' data in column C, See the uploaded image. I wrote the following in Cell D5 and copied it down. Column E just shows the formulas in in column D

=IF(C5="","",IF(C5>$C$4,"Up",IF(C5<$C$4,"Down",IF(C5=$C$4,"Even"))))

You can copy it as far as you want and it will be blank if there is no data in column C

Jamie

 

[airforceone]

I don't know if I get what you want to achieved but kindly see sample

2015 - 2022 newXNAPOLCOM SOURCE.xlsx
	A	B	C	D	E	F	G
1	Mr. John Doe			Base on Initial Output		Base on Previous Output
2	Initial Output	20
3	History	10		Below	B5 againts B4	Below	B5 againts B4
4		5		Below	B5 againts B5	Below	B6 againts B5
5		20		Even	B5 againts B6	Above	B7 againts B6
6		21		Above	B5 againts B7	Above	B8 againts B7
7		19		Below	B5 againts B8	Below	B9 againts B8
8		50		Above	B5 againts B9	Above	B10 againts B9
9		20		Even	B5 againts B10	Below	B11 againts B10
UPDATED (16)

Cell Formulas
Range	Formula
D3:D9	D3	=IF(B3=B$2,"Even",IF(B3<B$2,"Below","Above"))
F3:F9	F3	=IF(B3=B2,"Even",IF(B3<B2,"Below","Above"))

 

[NoahsArc]

I don't know if I get what you want to achieved but kindly see sample

2015 - 2022 newXNAPOLCOM SOURCE.xlsx
	A	B	C	D	E	F	G
1	Mr. John Doe			Base on Initial Output		Base on Previous Output
2	Initial Output	20
3	History	10		Below	B5 againts B4	Below	B5 againts B4
4		5		Below	B5 againts B5	Below	B6 againts B5
5		20		Even	B5 againts B6	Above	B7 againts B6
6		21		Above	B5 againts B7	Above	B8 againts B7
7		19		Below	B5 againts B8	Below	B9 againts B8
8		50		Above	B5 againts B9	Above	B10 againts B9
9		20		Even	B5 againts B10	Below	B11 againts B10
UPDATED (16)

Cell Formulas
Range	Formula
D3:D9	D3	=IF(B3=B$2,"Even",IF(B3<B$2,"Below","Above"))
F3:F9	F3	=IF(B3=B2,"Even",IF(B3<B2,"Below","Above"))

I think this is along the lines of what I need. Is there a way to make it so that it doesn’t recognize blanks - only cells with values in them?

 

[Joe4]

Just wrap it in another IF, like you did in your original attempt, to check for a value first:

=IF(C5="","",...