Price Brackets for retail scan data...

[andrewpearce]

Hi all,


Working with some raw scan data & for each SKU I want to assign the price break it falls into.


Price Breaks are standardised: $0-5 | $5-8 | $8-11 | $11-14 | $14-19 | $19-35 | $35+


I have a column that shows average sell price for each SKU & I want to use this to determine which price break the SKU falls into & then show the price break in a helper column?


Many thanks


AP

 

[Luke M]

In a column somewhere, list

0

5

8

11

14

19

35


In the column to the right, list whatever you would like to see returned in the cell (complete group range, name, etc). Your formula then is simply:

=LOOKUP(Your_Value,LookupTable)

 

[GODZILLA]

IF(AND(A1>0,A1<=5),"$0-5",IF(AND(A1>5,A1<=8),"$5-8,0)) etc

 

[andrewpearce]

Nice.


Many thanks


AP