Thursday, October 16, 2014

Classify numbers in a Range

Suppose we have data in excel. It has ticket ids in column A, column B is the status of ticket, column C is the Request date of the ticket, column D is the Latest update, column E is the Ticket age (days) and we need to classify Ticket age into different ranges in column F (Ticket age - Range) as follows: ">300 days", ">200 days", ">100 days", "100 days or less"

We can achieve this using If condition in cell F2:

=IF(E2>300,">300 days",IF(E2>200,">200 days",IF(E2>100,">100 days",IF(E2<=100,"100 days or less","")))) 

You then simply have to drag the formula down to the very last row having data to get the Ticket age - Range for all the rows with data.

Check out the image below which displays the final result:

1 comment:

  1. All of the casinos that we recommend have a number of} reliable deposit and withdrawal options. You can deposit cash utilizing most major credit cards, Bitcoin, wire switch or e-wallets like PayPal or Neteller. The Responsible Gambling Council’s 메리트카지노 motto is “all in for safer gambling” and it’s a dedication we additionally share. The on-line on line casino experience is supposed to be exciting, thrilling, and memorable, however guarantee that} it to be enjoyable over time, players must also be responsible. On the subject of on line casino bonuses, we simply can not underestimate their importance to both the player and casinos in the USA. Bonuses are sometimes how the best on-line casinos differentiate themselves against their competition, whereas players get the added benefit of free spins, or slightly further bankroll to play with.