histogramm and function

HELLO everyone i need some help regarding a function and a histogram.So i have a worksheet containing cities and villages and their population.Now i want to make a histogram with these spaces [max – 100.000), [100000 – 50000], (50000 – 10000] where the numbers represent the population of the villages.The problem is that there are too many villages and cities so in order to make it easier i tried to find a function that would "read" where villages and their poplution and will put the right space in the corresponding cell .The formual i used
=IF(AB13="yes";IF(D13>100000;"[max – 100000)";IF(AND(D13<=100000;D13>50000);"[100000 – 50000]";IF(AND(D13<=50000;D13>10000);"(50000 – 10000]");" ");" ");" ") the function is correct but it too long any way to make the same thing with a shorter formula....Also when i find the function how will i make the histrogramm?

thank you in advance