Categorising figures

  • Thread starter Thread starter xDeniumx
  • Start date Start date
X

xDeniumx

Hi, here's my problem

I got a list of products with their prices listed. I want to categoris
them. For example, if a price is in the 1 - 1000 range, I want th
letter 'A' to appear in a column next the price. How can I do that
 
Basic approach:
Create a table of product categories and price ranges, ie
MaxPrice Category
1000 A
2000 B
etc

Then use =VLOOKUP(price_cell,table_range,2)

possibly some tweaking required. See VLOOKUP in excel help
 
in the second column use an if condition like
=if(A1<1,"",if(A1<1000,"A",if(A1<2000,"B","C")))
you can have 7 such IFs

- Manges
 
in the second column use an if condition like
=if(A1<1,"",if(A1<1000,"A",if(A1<2000,"B","C")))
you can have 7 such IFs

- Mangesh


^
How do I put this condition and where do I write these IFs?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need Macro... 8
Auto-Calculate price based on width x height 0
Macro VBA Help please :) 7
Add a Value to a Cell Q 2
Loop thru xx No. of sheets until the four strValue combo's are found 6
Assembling large "array" 3
Access Updating an access table froma form that includes a listobox 0
Raspberry Pi 2 energy monitor with Inky pHAT (ePaper/eInk/EPD). 2

Back
Top