Join 3,564 readers in helping fund MetaFilter (Hide)

21 posts tagged with formulas. (View popular tags)
Displaying 1 through 21 of 21. Subscribe:

Related tags:
+ (15)
+ (4)
+ (4)


Users that often use this tag:
FireStyle (2)

Need help with conditional lists in excel

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

How do I create an amortization table where my payments change every period?

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

Help with Excel formula and table

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

stymied by excel

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

Spreadsheet Data Sorting

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

Help with lever formulas.

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

Getting Excel to reconcile two types of data

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

Need help making an excel formula

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

Conditional Formula Selection in Excel

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

Need excel formula to calculate the number of days in a date range, if they end within that range

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

Everything looks like a nail!

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

Excel formulas for Dummies, please.

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?

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

Please help me sort my vocabulary list in Excel!

Complicated Excel formula question involving text-search and Japanese characters. Can you help? [more inside]
posted by Vorteks on May 27, 2008 - 2 answers

complex dice probability make head esplode

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

Memorizing Math Formulas

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

What are the best rules, formulas and tricks in math?

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

How can I make rankings closer reflect votes?

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

e^i.pi+1=0

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

excelfilter

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 does foo cost?

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

Page: 1