Help with formula

[Fiveshorter]

Hi,

I have a sheet which lists the number of parts for every supplier. I have a column for a list of current month parts, last month parts and parts of the last 12 months. I have been trying to build a formula in order to compare the three columns with comments "NEW","DECREASE","INCREASE","SAME".

NEW - the parts are only new if column "parts 12 months" is blank or has a 0 in it.
DECREASE - There is only a decrease if the column "Current month parts" is less then "Last month parts"
INCREASE - There is only a increase if the column "Current month parts" is more then "Last month parts"
SAME - It is only the same if both current and last month parts are equal.

If the column "parts 12 months" is 0 or blank it is always new,

Any help on this would be greatly appreaciated!


[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Cust_ID[/TD]
[TD]Name[/TD]
[TD]Current month parts[/TD]
[TD]Last month parts[/TD]
[TD]Parts 12 months[/TD]
[TD]Comment[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]John[/TD]
[TD]2[/TD]
[TD]3[/TD]
[TD][/TD]
[TD]NEW[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]Jerry[/TD]
[TD]3[/TD]
[TD]4[/TD]
[TD]12[/TD]
[TD]DECREASE[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]Hannah[/TD]
[TD]4[/TD]
[TD]2[/TD]
[TD]34[/TD]
[TD]INCREASE[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]Zach[/TD]
[TD]5[/TD]
[TD]6[/TD]
[TD]23[/TD]
[TD]DECREASE[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]Terry[/TD]
[TD]6[/TD]
[TD]6[/TD]
[TD]1[/TD]
[TD]SAME[/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]Mark[/TD]
[TD]7[/TD]
[TD]8[/TD]
[TD]11[/TD]
[TD]DECREASE[/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD]Matthew[/TD]
[TD]8[/TD]
[TD]4[/TD]
[TD]10[/TD]
[TD]INCREASE[/TD]
[/TR]
[TR]
[TD]8[/TD]
[TD]Luke[/TD]
[TD]9[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]NEW[/TD]
[/TR]
[TR]
[TD]9[/TD]
[TD]John[/TD]
[TD]12[/TD]
[TD]12[/TD]
[TD]0[/TD]
[TD]NEW[/TD]
[/TR]
</tbody>[/TABLE]

 

[wideboydixon]

Book1
	A	B	C	D	E	F
1	Cust_ID	Name	Current month parts	Last month parts	Parts 12 months	Comment
2	1	John	2	3		NEW
3	2	Jerry	3	4	12	DECREASE
4	3	Hannah	4	2	34	INCREASE
5	4	Zach	5	6	23	DECREASE
6	5	Terry	6	6	1	SAME
7	6	Mark	7	8	11	DECREASE
8	7	Matthew	8	4	10	INCREASE
9	8	Luke	9	0	0	NEW
10	9	John	12	12	0	NEW
Sheet1

Cell Formulas
Range	Formula
F2	=IF(OR($E2="",$E2=0),"NEW",IF($C2<$D2,"DECREASE",IF($C2>$D2,"INCREASE","SAME")))

WBD

 

[Fiveshorter]

Thanks so much for this works like a charm!