Pages

Search

Excel Help Forum - Excel Formulas & Functions: Formula with Different Percentages

Feed2Mail notification - new post on Excel Help Forum - Excel Formulas & Functions
Formula with Different Percentages
I need to create a formula that allows me to multiply one cell by another, but the percentage in the second cell would change based on the number in the first cell. For example – the first 20 participants will pay $10, but if they have 30 participants, the next 10 get 15% off, and the 10...

Excel Help Forum - Excel Programming / VBA / Macros: recursive correlation

Feed2Mail notification - new post on Excel Help Forum - Excel Programming / VBA / Macros
recursive correlation
Hi guys! I was wondering if you can help me - i am a bit of an excel novice, but am trying to learn... :) I have a very long bivariate series. say, for example, 1....500000, in columns a and b. I then want to analyze the series into blocks of 100. I want to look at correlations for each...

Excel Help Forum - Excel General: Word slowing down using >paste special< with no links

Feed2Mail notification - new post on Excel Help Forum - Excel General
Word slowing down using >paste special< with no links
I am working on a Word document and pasting Excel tables and charts into same using Paste Special without the links. At regular intervals the Word document freezes and I have to wait a minute or 2 until it recovers. Is there a way of fixing this problem or is the only alternative to copy and...

Excel Help Forum - Excel Formulas & Functions: Converting a date serial number back to a date within a string

Feed2Mail notification - new post on Excel Help Forum - Excel Formulas & Functions
Converting a date serial number back to a date within a string
Hi all, I'm working on something that will return the applicable dates given certain conditions. I have one condition that would return a date range. I am currently trying to use, as an example: =if(A3="Marriage", A3&" - "&A3+31-DATE(A3+31)+1) In theory, this would return 10/15/2012 -...

Excel Help Forum - Excel Programming / VBA / Macros: Copy values from one CSV to an excel worksheet?

Feed2Mail notification - new post on Excel Help Forum - Excel Programming / VBA / Macros
Copy values from one CSV to an excel worksheet?
Is there a way that you can have a macro automatically copy and paste values from one excel sheet to another and possibly reformat some of the copied information?

Excel Help Forum - Excel General: Running clock in excel 2010

Feed2Mail notification - new post on Excel Help Forum - Excel General
Running clock in excel 2010
Hello. Is there a way to build a running clock that automatically scrolls through a selected range on a dashboard. I have attached a very basic mock upAttachment 188555 (http://www.excelforum.com/attachment.php?attachmentid=188555)

Excel Help Forum - Excel Formulas & Functions: Frustrations with Pivot Tabels

Feed2Mail notification - new post on Excel Help Forum - Excel Formulas & Functions
Frustrations with Pivot Tabels
Hello, I'm probably going to kick myself when this finally sinks in, but I'm having trouble getting data out of a pivot table. On the attached book the sheet 'Age of Stock' shows a stock item, a date and a quantity. On sheet 'Stock Report' in cell M4 i want to match the stock item...
Subscribe to: Posts (Atom)