Is there any reason why some people don't like to be "put on the spot" to answer questions? [more inside]
posted by CollectiveMind on May 23, 2009 - 60 answers

Mission Statements in Film: I'm working on a presentation about the importance of having clear objectives, and am interested in relevant video clips. [more inside]
posted by Pater Aletheias on Mar 28, 2007 - 23 answers

I could use your help hive mind. I'm currently taking an accounting course in college, and I'm having difficulties with financial statements and what gets reported where. I'm looking a mnemonic system that can embed this into my brain, as well as tricks and formulas which can help simplify this for me. [more inside]
posted by dropkick on Jan 18, 2007 - 6 answers

I've got an Excel spreadsheet with numbers ranging from 2,000 to 600,000. I want Excel to look at each cell and essentially categorize all of those into five categories in a new column. If the value is less than 10,000, I want Excel to give it a 1, if the value is between 10,000 and 50,000 I want it to be 2, if the value is between 50,000 and 100,000, I want it to return 3, if it's between 100,000 and 500,000, I want a 4, and if it's above 500,000, I want a 5. I tried the IF function, but I can't figure out how to a) make it recognize multiple variables, and b) I don't know how to tell it to look for numbers within a range. The Excel help section about arrays and lookups is fairly mystifying. Anyone got an idea? (I know I could sort the data and do this manually, but I'd like to learn how to do this Excel's way.) Thank you!
posted by stonefruit on Nov 9, 2006 - 14 answers