Programming question: I'm looking for recommendations for some kind of visualization tool to help me stay organized within complex nested loops and if statements.
[more inside]
posted by Cat Pie Hurts
on Apr 25, 2013 -
12 answers
How much focus, if any, on my "blemished" academic record, and my change of field, should I place in my personal statements for graduate school?
[more inside]
posted by anonymous
on Dec 7, 2012 -
12 answers
Need to get data from hundreds of pages of bank records into a spreadsheet. We have a scanner with a document feeder, but would love some recommendations on software/workflow ideas.
[more inside]
posted by capnsue
on Sep 29, 2012 -
6 answers
Help getting past statements from Citibank UK - any suggestions? Kafkaesque details within.
[more inside]
posted by thumpasor
on Jul 11, 2011 -
1 answer
Hou Hanru: On the Mid-Ground is a collection of curatorial statements and catalogue essays by a curator/critic. What other collections of curatorial statements might you recommend?
[more inside]
posted by Jagz-Mario
on Apr 20, 2011 -
2 answers
Is there an easy, automated way to receive PDF's of financial statements (bank statement, credit card bill, etc)?
[more inside]
posted by stilly
on May 6, 2010 -
6 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