21 posts tagged with formulas. (View popular tags)

Displaying 1 through 21 of 21. Subscribe:

I'm creating a workout training program in excel, and I want to show a range of data based on certain conditions. Using Excel 2010 More after the jump. [more inside]

posted by FireStyle on Feb 23, 2013 - 9 answers

posted by FireStyle on Feb 23, 2013 - 9 answers

Is it possible to create an amortization schedule in Excel when the payment amount, the principal amount, and the interest amount each year is unique? [more inside]

posted by lea724 on Mar 29, 2012 - 16 answers

posted by lea724 on Mar 29, 2012 - 16 answers

I need to a formula that will calculate accumulated points based on the number of sales an employee had during a quarter, when there are certain milestones he or she has met. [more inside]

posted by desjardins on Feb 21, 2012 - 8 answers

posted by desjardins on Feb 21, 2012 - 8 answers

There has to be an answer for this, but I just can't figure it out. In Excel, I've got 5 columns (A-E). I need to return a list of values from column A if either column B or C equals 'foo', *and* if either column D or E equals 'bar'. What's the magical formula (or whathaveyou) that will make this happen? For bonus points, results need to appear on a separate tab than the source data.
asking on behalf of mrs spinturtle, I personally have no idea what I'm talking about.

posted by spinturtle on Mar 17, 2011 - 6 answers

posted by spinturtle on Mar 17, 2011 - 6 answers

Excel Spreadsheet - AutoMagically re-arrange data from one sheet to many based upon Alphabet? [more inside]

posted by DrtyBlvd on Jan 28, 2011 - 7 answers

posted by DrtyBlvd on Jan 28, 2011 - 7 answers

Mefi engineers please help me. So my theatre company might be doing a show that requires a set to tilt back and forth. I need help figuring out the math for fulcrums and lever distances. [more inside]

posted by Uncle on Apr 18, 2010 - 18 answers

posted by Uncle on Apr 18, 2010 - 18 answers

Excel Filter: Say I have a spreadsheet with two types of data. a) list of transactions with date/time + transaction, and b) days with traffic. How do I reconcile the two sets of data swiftly & easily? [more inside]

posted by Muffy on Feb 12, 2010 - 8 answers

posted by Muffy on Feb 12, 2010 - 8 answers

Please bear with me, as I'm having difficulty wording this question. I'm trying to use excel to add values that belong to a list. Basically, the list has a entry, each entry has a value, and I want to total the values of like entries. [more inside]

posted by FireStyle on Dec 2, 2009 - 4 answers

posted by FireStyle on Dec 2, 2009 - 4 answers

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

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

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

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

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

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

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

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

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

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

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

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

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

posted by the giant pill on Jan 1, 2006 - 17 answers

Page:
1