Hi, I need some help with these complicated logical functions please. I think I know how to write each function but the combination is too complicated for me. Thanks!!
If item (column A) is unique return the value 10
If not (If item is duplicated)
then:
For the smallest unit return the value 7
For the medium unit return the value 8
For the largest unit return the value 9
If all units are equal for the same item:
For the smallest price return the value 7
For the medium price return the value 8
For the largest price return the value 9
item | units | price |
A | 1 | 15 |
A | 1 | 15 |
B | 1 | 5 |
B | 2 | 10 |
B | 3 | 15 |
C | 1 | 15 |
C | 1 | 20 |
D | 1 | 10 |
If item (column A) is unique return the value 10
If not (If item is duplicated)
then:
For the smallest unit return the value 7
For the medium unit return the value 8
For the largest unit return the value 9
If all units are equal for the same item:
For the smallest price return the value 7
For the medium price return the value 8
For the largest price return the value 9