Sponsored White Papers, Webcasts, and Downloads
TechRepublic Resources
- If Statements
- I am working on a spreadsheet in Excel. I would like to see if I can get this to do the following, if k23:k27>0 then I need these values to be avareaged without including the 0 value.Also, I need some help with the following, similar to the previious one:...
- Tags: beachlabrat@..., A1:A20, Sumif
- Discussion threads 2007-10-22
Additional Resources
- How to refernce a static increment of rows in one column,ie every other
- Example: I would like to reference cells c1:c5 to the values in cells a1, a5, a10, a15, a20.Thank you to responders
- Tags: yonatan.t.carl@...
- Discussion threads 2007-05-28
- Help with the IF Function in Excel
- Hi, I am preparing a Tax Calculator using Excel but can't get the formula right. Here's an example:Gross annual income:Below 1000 should be tax free1000-2000 should pay 2202000-3000 should pay 330........above 10,000 should pay 1100 etc, etcI tried using the IF Function but still received errors. Urgent help is welcomed.Try...
- Tags: mamahtm@..., software, Microsoft Excel
- Q&A 2006-08-21
- Multiple Rows Combined Into One Row with Flat Files & SSIS
- I have seen several articles and code snipets for combining multiple rows into one row. I would like to share an example and then ask a few questions.Flat file contains record type, sequence number and detail - ALL AS A ONE COLUMN ROW as input on SSIS. This flat file...
- Tags: csmith@..., Flat File, SSIS, A20 01 2603030 PO Box 27BaltimoreMD20110 A24 01 2121211Mike
- Discussion threads 2007-11-13
- if condition
- plz find the formula below=if(a1=1,"one",if(a1=2,"two",if(a1=3,"three","four")))but i need only one if two check all the conditionsLooks rightThe code works as expected when I pasted into a worksheet. Can you try to be more descriptive of your exact problem? Are you getting an error or unexpected results?
- Tags: sureshchinna_sb@...
- Discussion threads 2007-10-19
- Excel formula
- Please help Value in Cell A1 is copied into cell B1 and new value is entered in A1B1 should now show old value of A1 plus new value of A1in other words B1=B1+A1How do I do this in Excel. Tried to use if statement, cant figure it outThanksYou will need...
- Tags: ichu50, Microsoft Excel, software
- Q&A 2005-08-20
- excel - keep previous cell data
- I have a cell A1 that is updated every 5 seconds from data I receive from a DDE server (those data are just numbers between 0 and 10) What I need is to store every minute the number from A1 in order to keep historical data of those numbers. So...
- Tags: evalweb@..., cell
- Discussion threads 2007-08-01
- Sort in Excel and replacing chars
- I have 18000+ rows in excel, each row has a different value on it. For Example:PTH03020WAZPTH03030WAZPTH03030WADPTH03050WAZPTH03050WADPTH03050WAH.PTH03060WAZPTH03060WADPTH03060WAHPTH03060WAH.Now if the first 8 chars are the same, I want to remove the remaining chars and replace with "Space Series"Can anyone help with this?!Thank you in advance!RossNeed a little more infoAre you wanting a...
- Tags: rmurgatroyd@..., Microsoft Excel
- Discussion threads 2007-11-21
- Anatomy of an Excel formula: Using functions to perform calculations
- CorrectionsThe textIf you read this literally (A1 : D1, for example), it reads "the contents of every cell between A1 and B1, inclusive of A1 and B1". should readIf you read this literally (A1 : D1, for example), it reads "the contents of every cell between A1 and D1, inclusive...
- Tags: hardware, lschell, Microsoft Excel,
- Discussion threads 2005-08-23
- Excel ~ Special Cell Formatting
- Does anyone know how to format maybe even build a specialized format to apply to a specific Cell. For instance, I want a specific cell (A1) to capitalize anything that is entered into it (cell A1). (I don't want one cell to show the contents of another cell.)...
- Tags: Microsoft Excel, patricia.lynn@..., cell, Cell
- Discussion threads 2007-10-10
- IBM System Storage N3700 A20 Setup
- This paper discusses how to set up clustered systems, using IBM System Storage N3700 Model 2863-A20 as an example. The paper covers hardware setup, such as cabling and connecting to local area networks LANs and expansion shelves such as the System Storage EXN2000 expansion unit. The paper explains the initial...
- Tags: Storage, Setup, IBM Corp.
- White papers 2007-02-21
- MICROSOFT EXCEL 2003
- Can anyone help. IF THE LETTER "A" IS ENTERED INTO A CELL BETWEEN (A1:A40) THEN THE NUMBER Fig"1" IS PLACE IN CELLS (B1:B40) If another "A" IS ENTERED BETWEEN (A1:A40)THEN Fig "2" IS PLACE IN CELLS (B1:B40)AND SO ON NUMBERING CELLS IN SEQUENTIAL ORDER 3,4,5. SO IF THERE ARE 5...
- Tags: A1:A40, arrays, B1:B40, buzby@..., excel, feedback, formulas, Microsoft Corp., Microsoft Excel, off-topic, programming, windows
- Discussion threads 2007-01-19
- Create a summary report in Excel with data consolidation
- If you have a number of Microsoft Excel worksheets that contain related data, you'll likely need to create a report that consolidates and summarizes the data. If those worksheets are laid out identically to one another, this tip will show how you can have Excel's Data Consolidate feature consolidate the...
- Tags: Microsoft Excel, Microsoft Office, Mary Ann Richardson, Collapse dialog, worksheet, grade, Microsoft Office Suite Excel Tips Newsletter, Consolidation, Student, Office Suites, Software
- Technical articles 2005-05-17
- A1 DVD Audio Ripper (exe)
- A1 DVD Audio Ripper supports DVDs to MP3, WAV, WMA, and OGG with excellent output quality. A1 DVD Audio Ripper fully supports ID3; you can edit the music info easily and professionally. A1 DVD Audio Ripper has a nice and easy understandable user interface, and the quick settings panel can...
- Tags: DVD-Audio, DVD, Consumer Electronics, Personal Technology, Home Entertainment
- Software downloads 2008-01-16
- A1 DVD Ripper (exe)
- A1 DVD Ripper is tool for converting DVDs to VCD, SVCD, WMV, AVI DivX with excellent output quality. A1 DVD Ripper supports DivX, to compress/encode a full-length movie at near DVD-quality that's small enough to fit on a single CD. Built-in power multiplexing engine, A1 DVD Ripper support Hyperspeed DVD...
- Tags: DivXNetworks, WMV, A1 DVD Ripper, DVD, Consumer Electronics, Digital Video, Personal Technology, Home Entertainment
- Software downloads 2007-10-02
- Excel argument/formula question
- Let's say I have the POTENTIAL to have data in cellS A1, B1, C1 and D1. In cell E1 I want to add all four cells together. That's easy. Now in cell F1 I want to say take the total from E1 and divide it by the...
- Tags: Rosstamon, Microsoft Excel, A1:D1, cell
- Discussion threads 2007-07-13
- Excel 2003 Hyperlink
- I have a spreadsheet where I have many columns, okay? Now I have used the EDIT HYPERLINK and selected PLACE IN DOCUMENT where I enter in a cell. So far with me? Now what happens is when I add new rows, say dozens of new ones, the links still work...
- Tags: cell, BorgInva, software, Microsoft Excel
- Q&A 2006-09-05
- A1 Google Toolbar (exe)
- The Quicknation A1 Google Toolbar allows you to perform searches with nearly all the Google products. The A1 Google Toolbar also includes more than 100 top search engines. Allow you to perform searches with the same keywords on different Google tools.
- Tags: Google Toolbar, Google Inc., Toolbar, Quicknation A1 Google Toolbar
- Software downloads 2006-05-18
- Two Broadband connections and One SBS 2003 server
- Hello, I have two broadband connections(one with 256kbps and other with 512kbps )with me and the server has two network adapters.[Two broadband connection because if one A1 goes downor is dead Internet operates on other B1.] Now, can I merge these (A1 and B1) in Two N/W adapters on my...
- Tags: acmahajan@..., broadband, hardware, it management, Microsoft Windows Small Business Server, Microsoft Windows Small Business Server 2003, network management, networking, server, windows
- Discussion threads 2007-01-08
- IS THERE A FORMULA TO REPEAT WHAT EVER IS IN A CELL?
- I have to repeat the same information in a different cell. But instead of typing it twice, can I create a formula in the 2nd cell to repeat whatever is in the 1st. cell? Sometimes it will be a number and sometimes it will be text typed into the...
- Tags: cell, suzanne_juszcyk@...
- Discussion threads 2007-02-26
- << Previous
- page 1 of 1
- Next >>
