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!

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

<tbody>
</tbody>

 

[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!