How can I create an Excel worksheet which uses something like VLOOKUP (or anything which works in a similarish way) not to pull values, but formulas? [more inside]
posted by Bugbread on Oct 22, 2009 - 7 answers

I need a formula to help calculate the number of days as compared to a range. Importing a CSV for a query to show bookings within the date range of 9/1 to 9/30. Some bookings are booked through the entire month and some are partial. I need to figure out the number of days or percentage for the bookings that don't run all the way through the query range. [more inside]
posted by malcommc on Oct 1, 2009 - 9 answers

Asking_for_friendFilter/ExcelFilter: I’ve built a pretty basic calculator in Excel to help people figure out how much to bill for partial months vs. full months. As you can guess, there's... [more inside]
posted by littlerobothead on Jul 8, 2009 - 2 answers

This is probably a pretty basic Excel formula question, but I'm clueless. [more inside]
posted by zardoz on May 27, 2009 - 3 answers

Intense Excel Question: Calculate a rolling YTD/YTD that is dynamic? [more inside]
posted by Carialle on Sep 11, 2008 - 10 answers

Complicated Excel formula question involving text-search and Japanese characters. Can you help? [more inside]
posted by Vorteks on May 27, 2008 - 2 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

Any tips or tricks to memorizing financial math formulas [more inside]
posted by JaySunSee on Jul 16, 2007 - 11 answers

MeFites: Share with me your favorite math tricks, truisms and formulas that clarified and simplified math problems and made life easier in high school and college. [more inside]
posted by dropkick on Feb 24, 2007 - 59 answers

In a ranking system, when you have multiple items with similar rankings, how can you give more weight to those with the most votes? [more inside]
posted by bjork24 on Nov 18, 2006 - 14 answers

Most convenient way to insert equations into web pages? [more inside]
posted by Mapes on May 31, 2006 - 11 answers

I need help with an Excel formula. Warning: this may venture into the realms of calculus. Maybe. [more inside]
posted by thecjm on May 21, 2006 - 7 answers

How much money do you save by doing it yourself? [more inside]
posted by the giant pill on Jan 1, 2006 - 17 answers