Two criteria with result in third blank cell

[jomu84sa]

Hello everyone,

I have i problem getting my job done on time because I can't automate one job in excel.

We sell our products to lets say 100 stores/markets. And we have around 10 products. Each store has their prices for our products.
I need to put information from all this stores about all our 10 product into 4 price range kategories.

Store "Love" sells our product "Beer 0.33l" at 1.50
Store "Happy" sells our product "Beer 0.33l" at 1.62
Store "Corner" sells our product "Beer 0.33l" at 1.75
Store "Smiley" sells our product "Beer 0.33l" at 2.00

Store "Love" sells our product "Wine 0.75l" at 2.50
Store "Happy" sells our product "Wine 0.75l" at 2.70
Store "Corner" sells our product "Wine 0.75l" at 2.80
Store "Smiley" sells our product "Wine 0.75l" at 3.00

And so on for the next 8 products and 100 stores.

I have 4 exact price range kategories for each product.
Lets say for "Beer 0.33l" 1. ktg is 1.55 and below, 2. ktg. is 1.60 between (and equal) 1.70 3. kategory is between (and equal) 1.71 and 1.80 4. ktg is 1.90 and higher


How to write a formula if value in one cell is specific text "Beer 0.33l", and the price in another cell is 1.50 and lower (1 ktg.), is 1.60-1.70 (2. ktg) and 1.80-1.90 (3. ktg) and higher than 1.90 (4.ktg) so depending of whether is price in 1. ktg in cell would write KATEGORY 1, and like so for the next three kategories..

??

Sorry for my bad english..

By.

[daffodil11]

Make a table of conversions that lists them.

Column A: product
Column B: every price combination of A
Column C: the category of each

Then writing a formula for every entry is as simple as telling it to look at table.

[jomu84sa]

Formula help - COUNTifs, or SUMifs or?
Hello,

If criteria in cell A1 is specific text, for example "XX 0.33gal" and if in comun B, lets say cell B1 the price is 1.50, which formula to use if I want in blank cell C1 to be written "KATEGORY1".
If the price in B1 is higher or equal to 1.51 and the price goes until and equal to 1.60 I want to be written KATEGORY 2. If the price is from 1.61 to 1.70 KATEGORY 3, and above 1.7 KATEGORY 4.

How could I do this?

Thans in advance..

[alansidman]

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.

Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

To change a Title go to your first post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)