First off, I apologize if this is the wrong place to put this. I'm new! Anywho. I am in need of a formula that is too complex for me to think of. The jist is: Say, there's a number in cell F3. What I want to do is compare that number to a series of ranges (and by range, I mean stuff like 0 through 9, etc.), see which range the number falls in, and put a number in another cell based on that range. Complicated, no? I'll put it in context. If the number in cell F3 is between 0 and 9, put a 0 in cell I3. In the same function, If the number in cell F3 is between 10 and 19, put a 1 in cell I3. The function would continue on with different ranges and different outputs, all arriving in the same cell. I hope all that makes sense. I'm working on an important spreadsheet and really need to figure out a function like this.
