Sponsored White Papers, Webcasts, and Downloads
Additional Resources
- Excel ANNOYANCES: Formula ANNOYANCES
- Transforming the data in the worksheets using formulas is what Excel does best. What could be annoying about that? Lots! Take one horrible example: consider what happens when one creates a formula in one cell and copy it to another cell. If one doesn't build the formula just right, the...
- Tags: Formula, Cell, Microsoft Excel, Microsoft Office, Office Suites, Software
- Book chapters 2004-12-08
- Formula not working always in excel suing VBA
- Hi alli've used a formula something likeactivesheet.cells(row,col).formula = "='C:Documents and SettingsAdministratorDesktop[sdfsdf.xls]Sheet1'!$A$12"this line will be in a loop , iterating for a couple of rows.But what is happening is, the formula works fine for most of the cells,but for a couple of a cells, ....instead of the result, the formula itself...
- Tags: redvamsi@..., Microsoft VBA, cell
- Discussion threads 2007-10-04
- Sum cells in as yet uncreated worksheets
- HelloI am trying to reproduce a formula I found in a locked worksheet. Copying and pasting formula has not worked.Formula is =sum('Day (0):end'!d16).The formula is designed to add values automatically when new sheets are added. If it helps am adding new sheets via a macro.Please help
- Tags: morrison_paul002@...
- Discussion threads 2007-07-24
- EXCEL formula help
- I need to understand why excel is not allowing the same formula, that exists both above and below... I am only doing a sum of 7 cells on the same row? but if I enter the formula even with prens, or begin the formul with a 0, or even backward,...
- Tags: dawn.prentice@..., Microsoft Excel
- Discussion threads 2007-07-01
- iFD Formula (exe)
- iFD Formula is a compact powerful utility for Pocket PC that allows you to work with a sufficient set of formulas (mathematical, physical, and electrical). You can also add your own formulas where you can add new formula categories, new formulas and their parameter description. The calculation is easy and...
- Tags: Formula, Calculation, iFD Formula, Pocket PC, Handhelds, Operating Systems, Desktops, Hardware, Software
- Software downloads 2006-02-02
- A formula to return a formula in Excel???
- I have a situation in which several hundreds of sheets in the same workbook require the same formula to be enterred. Is there a way short of building a function that I can enter the formula once in a 'Legend' sheet, and then use a reference to that cell in...
- Tags: bubba_barnett@..., Cell, Cell A1, Sheet1
- Discussion threads 2007-04-24
- Excel Formula that doesn't repeat when you use drag and fill
- I'd like to create a formula for a spreadsheet and populate all the line items without having the formula repeat over and over. Someone did it in one of their spreadsheets but would not share how he did it.Thanks,SusanI'm not sure what you mean.Do you want to copy the...
- Tags: PRODUCTIVITY, Microsoft Excel, smdonahue@...
- Discussion threads 2007-06-22
- Formula dragging in excel
- I was just wondering, when you drag a formuladown the page, is it possible to drag only the formula and not the cell format. eg. if there is a formula in a cell which has a border, can you drag the formula to other cells without dragging the cells border??
- Tags: nickl@..., cell
- Discussion threads 2007-08-01
- Do not update formula when inserting rows in Excel
- In Excel, I want to be able to insert a row but NOT update a formula referencing that row. For example in Cell B1 I have the formula =AVERAGE(B3:B33) now when I insert a new row at row 3 the formula automatically changes to =AVERAGE(B4:B34) I want to ALWAYS average...
- Tags: 7s1u7le79ba7089@..., Microsoft Excel
- Discussion threads 2007-05-03
- Formulas in Excel
- I have created a formula in Excel as below: =SUM(IF(Data1!B1:B155=B9, IF(Data1!C1:C155=AD10,IF(Data1!I1:I155 = 2, Data1!L1:L153,0),0),0))But it is not displaying the result in the cell. If i am in the formula and do a F9 Calculate it will bring the correct result through but will make the formula disapear. How can i...
- Tags: feedback, Microsoft Excel, off-topic, simon_sez_it@...
- Discussion threads 2007-01-11
- Copy an Excel formula without changing its cell references
- After having written the formula for instance like=A1*B1/D1To achieve the result of copying and pasting so that the cell references do not change all you need to do is to modify the formula like this=$A$1*$B$1/$D$1now the cell references are ab
- Tags: ASAP Utilities, cell, cell reference, feedback, gbramley@..., Microsoft Excel
- Discussion threads 2006-11-01
- Builder.com is dead, long live Builder.com
- Anybody out there an attendee of Web.Builder?Just curious, were any of you attendees at the Web.Builder conferences in the late 1990's? If so what did you think? What did we do right, what did we do wrong?
- Tags: RexWorld, Web.Builder
- Discussion threads 2007-07-11
- Formula 1 RSS Feed (widget)
- As requested by a Uni friend of mine, I've devised a widget displaying news about Formula 1. Follows the same layout as my previous widgets, and the same credits apply. Formula 1 RSS Feed are proving more popular than expected. This version is the first release on CNET Download.com.
- Tags: RSS Feed, RSS, Internet
- Software downloads 2007-07-23
- Copy an Excel formula without changing its cell references
- If you copy a formula from one place to another, Excel will want to readjust the references to reflect the change. However, if you want the formulas to stay the same, Mary Ann Richardson can help end the confusion. When working with a spreadsheet, when you copy a formula...
- Tags: Microsoft Excel, Microsoft Office, Mary Ann Richardson, cell reference, Microsoft Office Suite Excel Tips Newsletter, Formula, Office Suites, Software
- Technical articles 2006-10-31
- transpose w/ formula
- hi everyone,what i want to do is:i want to display the contents of a row on a column, very much like transposing data but with a formula. can it be done?cheers
- Tags: msalvs@...
- Discussion threads 2007-05-23
- Changing formulafields in crystalreports
- Hello-when i am trying to set the formula field text second time to the same ReportDocument object i am getting a "formula not found" error.please help me! Suresh
- Tags: sureshts@...
- Q&A 2006-01-24
- Excel 2003
- Good morning:I have a formula I use in Excel to find the average of three totals, which then puts the results in a seperate column. Is there a way to lock the result so if I delete the formula, the result does not disappear when I delete the formula?Thanking...
- Tags: Microsoft Excel, Microsoft Office
- Q&A 2005-03-28
- A Note on an Analytic Model for Slow Start in TCP
- Sikdar et al has provided a formula to model the window increase pattern given the mechanics of delayed acknowledgements. This paper shows that their sum formula significantly underestimates the iterated sum for rounds greater than seven. The approximation error grows exponentially. It also derives a more accurate sum formula whose...
- Tags: Formula, TCP, RMIT University, Approximation Error, Tcp/Ip, Networking
- White papers 2007-01-01
- F1 Championship Season 2000 (sit)
- Re-live the gladiatorial battles between Michael Schumacher and David Coulthard or tear up the record books and take an outsider to World Championship glory. With in-depth behind the scenes technical support from the Orange Arrows and Benetton Formula One teams never before has the game player been able to enter...
- Tags: Team, Feral Interactive, Games, Team Management, Personal Technology, Management
- Software downloads 2008-03-19
- << Previous
- page 1 of 1
- Next >>
Harnessing the power of waves
Planting solar gardens
Fill your car for $1.10 a gallon?