histogramm and function

[darkdemon]

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

[mgaworecki]

This seemed to work for your formula:

=IF(D2="yes",IF(C2>100000,"[max – 100000)",IF(AND(C2<=100000,C2>50000),"[100000 – 50000]",IF(AND(C2<=50000,C2>10000),"(50000 – 10000]",""))),"")

I put it in E2 and filled it down. (You may need to change the ","s to ";"s)

I don't think it was too long, I think the problem was you got an error saying you put in too many arguments for the one particular IF statement.

As for making the histogram, I am not sure how you would do that. I will keep working on it though if I get time

[darkdemon]

Thank you in worked ...i think there was a problem with the end of the function and not the IF
Now any help on how to do a histogramm would be appreciated