First  |  Prev |  Next  |  Last
Pages: 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41
How do I calculate escalation rates using dates and a set value
If I have a projected that needs to be escalated using start and completion dates by a certain percentage per year, how do I write the formula. For example if my project starts May 26, 2010 and lasts until may 26 2014 I want to add escalation to midpoint at 4% per year. ... 27 May 2010 18:11
Referring to a portion of a column
Knowing that $A:$A can be used in a worksheet function to refer to all cells in column A. Is there a way to refer to all cells below a starting point? (i.e., I want to CountA() all cells below my header rows). I can't just subtract the number of header rows because the CountA() of those varies. -- Thanks, Le... 27 May 2010 19:18
ISNA and ISERROR functions
Try these formulas 'If the lookupvalues is not found it will return a na() error =VLOOKUP("something",Sheet2!A:B,2,0) 'returns true if value is not found and false if value is found =ISNA(VLOOKUP("something",Sheet2!A:B,2,0)) 'Handle na() errors using IF() =IF(ISNA(VLOOKUP("something",Sheet2!A:B,2,0)),"Not f... 27 May 2010 18:11
Help writing a formula
I have a huge database that I need to create numbering for each line like this example: AK-233 (2 letter state, a dash, and 1-4 digit number), but the number doesn't change each line - sometimes the number will be duplicated on multiple lines because those lines have the same title, I also need to create anothe... 27 May 2010 18:11
Excel 2010 not opening in maximized view
Hi, I am starting to use Office 2010 and Excel is only opening in a small window. Does anyone have knowledge on how to get it to open in full window (be the size of my screen)? All other office applications open in full view. Thanks in advance. ... 28 May 2010 13:46
2003 Office Excel .tmp files not deleted upon file save
Hi, Have you solved this problem? I'm facing the same problem as you, but I can't find the solution yet. Please let me know if you've got it. Best regards. Gus "KTM Warrior" wrote: When saving file, Xcel generates .tmp file xls.~RFe17931.TMP in same folder with the .xls file. Can manually delete, but i... 27 May 2010 18:11
Find and Replace
We are using a scanner to input a barcode number into "Find What" box in find and replace in excel. Is there a way to make it stay highlighted for the next input without having to use the mouse to double click to re-select after each input? ... 27 May 2010 18:11
How do I insert a dot leader in Excel?
I want to type a brief description in a cell and insert a dot leader to the next cell which contains a money amount. ... 27 May 2010 19:18
Conditional Formatting & Macro
Is it possible to write a Macro to make changes 2 another Macro. I have a complicated macro which may have 100 formulas, each day I add data which then requires I make the same change to all these formulas & where they r applied by the macro 2 a worksheet. By that I mean I must add the same number 2 the row num... 27 May 2010 18:11
First  |  Prev |  Next  |  Last
Pages: 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41