How do you find a number that minus a percentage of itself is a certain number? [more inside]
posted by JulianDay on Dec 6, 2009 - 7 answers

MathFilter, NumericSimplificationFilter, RecursionFilter, ExcelFilter: Where X_1,X_2,...,X_n can be any number, is there a name, simplified series, or equation to describe: (X_1)+(X_1+X_2)+(X_1+X_2+X_3)+...+(X_1+X_2+...+X_n) ? Seriously seriously insane exel implementation question inside. [more inside]
posted by Nanukthedog on Aug 28, 2009 - 16 answers

Am I distorting my data, and not showing the true picture? [more inside]
posted by matholio on Nov 18, 2008 - 9 answers

I have to create an excel sheet to keep track of a book budget - in the most basic terms, I will have a total budget figure, and I want to subtract invoice figures to keep a running total. Here's an example of what I want the sheet to look like: http://i109.photobucket.com/albums/n46/coollibrarian/excel.jpg The simpler the better. [more inside]
posted by coollibrarian on Jul 26, 2008 - 7 answers

Can I use Excel to loop through lists of names and sum up numbers for each name, without having to define the cell ranges that correspond to each name? [more inside]
posted by korres on Feb 5, 2008 - 4 answers

I need a tool to help me analyze the probability of certain events occurring regarding a pool of X dice for a game I am creating. See my examples below. [more inside]
posted by DetonatedManiac on Dec 21, 2007 - 7 answers

In Excel 2007, I need advice on how to round a series of prices to either a $0.50 ending, or a $0.95 ending. [more inside]
posted by Futurehouse on Dec 20, 2007 - 10 answers

Graphing question: My boss has an idea of how our data should be presented. Please help me figure out how to make it happen! [more inside]
posted by nprigoda on Jul 4, 2007 - 5 answers

How can one create a best fit ellipse around a cluster of (x,y) points in a scatter plot within Excel? [more inside]
posted by geonags on Apr 12, 2006 - 33 answers