Hi, please can someone help with a formula to do the following? I am doing a price list for kitchen cabinets and the doors for these cabinets fall into price groups. I have worked out averages for all the doors and divided a value from and to into groups:
0-13 group 1
14-20 group 2
21-27 group 3
28-34 group 4
35-41 group 5
42-48 group 6
49-55 group 7
56-63 group 8
What I need to do is if the average of a certain set of doors is 36 then I nee the a cell to display GP5, 21 display GP3 etc etc...
Please be patient with me I am a beginner with Excel but am very keen to learn more. Great piece of software :-)
Thankyou for your help.
Bookmarks