Fiveshorter
New Member
- Joined
- Jul 14, 2017
- Messages
- 18
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!
<tbody>
</tbody>
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>