Did you mean
formula (117 results)
Sponsored White Papers, Webcasts, and Downloads
TechRepublic Resources
- sort by:
- Relevance
- Date
- Popularity
- Save effort by defining names for Excel 2007 formulas
- Simplify things for your Excel users: Name the formulas they'll need to use. That way, they won't have to create the formulas for themselves. by Mary Ann Richardson
- Blog posts 2008-08-04
- Quick access to Excel formula bar via keyboard
- A quick keyboard shortcut puts you right into the Formula bar. You don't need the mouse at all! by Susan Harkins
- Blog posts 2008-07-25
- Quickly document Excel formulas
- You can document an Excel worksheet easily by printing formulas. Store the hard copy with the application's documentation. by Susan Harkins
- Blog posts 2008-07-06
- Calculating Access fields with Null values
- Don't let Null values derail your formulas. See how to use the NZ function to convert the values to zeroes. by Mary Ann Richardson
- Blog posts 2008-07-01
- Use named ranges for absolute references in formulas
- There are a number of ways to design absolute references in formulas. For example, in an order form, you might use a Lookup function to determine the shipping charges from a shipping table, as shown here. If you use the cell range for...
- Blog posts 2008-06-10
- Use an array to add time components in Excel
- I recently acquired a worksheet with time components entered separately. I have no idea why they did this, as doing so seems inefficient and unnecessary to me. Just the same, I had to work with it. The first problem was getting Excel to recognize integer values as...
- Blog posts 2008-05-26
- Geek Trivia: Everything old is new (Coke) again
- According to conventional wisdom, the secret formula for Coca-Cola is amongst the most prized and inscrutable mysteries of modern food science. Only the most privileged executives and researchers of The Coca-Cola Company are privy to its exact formulation. So irreplaceable is their access, these anointed individuals must never travel together...
- Blog posts 2008-05-06
- Copy hundreds of rows of Excel formulas in three steps
- Excel provides a number of ways to copy formulas. You can use Excel's Autofill feature or, as an alternative, select the cells you wish to copy to, enter the formula in the active cell, and then press [Ctrl][Enter]. These methods are fine for copying formulas down a column of cells...
- Blog posts 2007-12-04
- OOXML or OOPS? Microsoft blunders in its open document specification
- A performance architect for a Fortune Fifty corporation deconstructed Microsoft's MS-OOXML specification for open documents and found many, many poor definitions and more just plain wrong formulas. Rob Weir reports in his blog how Redmond allows mixing of radians and degrees in seven functions (remember the...
- Blog posts 2007-07-11
- Use dynamic ranges to make your Excel spreadsheets easier to understand
- Give your numbers more distinct meanings in Excel with dynamic ranges. By using the OFFSET function and naming feature, you can give labels to your formulas, making them easier to find and reference. You can make Excel formulas easier to understand by using named ranges. For example, the...
- Technical articles 2007-04-03
- Make Excel spreadsheets easier to read with natural language range names
- Use the labels already in your Excel spreadsheet to help you easily understand what your formulas mean. Mary Ann Richardson gives meaning to the mystery of formula results. Whether you are using Excel spreadsheets for training or to present an analysis of last year's sales results, it is...
- Technical articles 2007-02-13
- Calculate your procrastination with the Temporal Motivation Theory
- Just when I thought I understood the hows and whys of procrastination or at least how and why I procrastinate, someone came along and turned it into a mathematical equation. Check out this recent news story: "A formula for procrastination."According to the article, "University of Calgary professor Piers Steel, a self-described reformed...
- Blog posts 2007-01-12
- Excel Formula Help
- Hello Everyone,I want to create a simple project-like Excel workbook.It would be setup in the following manner:A1 = taskB1-L1 = empty cells denoting percent complete (each cell = 10%)H1 = %CompleteWhat I want to do is put in H2 a value - 10-100 (in increments of 10) and the appropriate...
- Discussion threads 2006-12-19
- Avoid nested formula errors with Excel's Insert Function dialog box
- Excel's nested formulas option may be useful, but many people find it a challenge fraught with potential errors. Mary Ann Richardson explains an easy way around it: use the Insert Function dialog box. Entering nested formulas manually into Excel can often lead to syntax and typing errors. For...
- Technical articles 2006-12-19
- Get Excel to calculate formulas with circular references
- Don't go around in circles unnecessarily—when you have a circular reference in Excel, the program usually gives you an error message. However, if you want to calculate repeatable formulas, you can get Excel to do circular calculations on your terms. Mary Ann Richardson tells you how. In Excel, formulas...
- Technical articles 2006-11-07
- 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...
- Technical articles 2006-10-31
- Excel - How change existing name field data to a common format
- We have a large mailing list that includes a name field populated with First name, Middle name/Initialsif one exists, and finally Last Name. Sometimes there are periods after initials, sometimes not, and sometimes no initials at al. Is there a generic formula that doesn't have to be run...
- Discussion threads 2006-10-25
- Calculating financial values in SQL Server
- Although SQL Server 2000 and 2005 do not include much in the way of financial functions, Arthur Fuller shows you how to use the present value and future value functions to calculate financial functions in SQL Server. SQL Server 2000 and 2005 do not include much in the way...
- Technical articles 2006-08-23
- Excel Formula Doesnt Update or Refresh
- Hi Guys,I had this formula in my one of columns:=SUMPRODUCT(C3:M3,$C$2:$M$2)/(((SUM($C$2:$M$2))-(SUMIF(C3:M3,"NA",$C$2:$M$2))-(SUMIF(C3:M3,"",$C$2:$M$2))))Now When I change any cell values on the worksheet normally the figure on the formula should be changing but it doesnt update or refresh the formula some how...How can I solve this problem....?Regards,From the Excel 2003 helpyou can do the...
- Discussion threads 2006-07-25
- Find the top 10 values in an Excel range without sorting
- Nice formula but...I just tested the formula and it did work only if you replace commas with semicolons. =SUM(LARGE(SalesData;{1;2;3;4}))=)Works fine with , for meUsed formulae just as in article works fine.Function returns top/bottom ten valuesThis is a neat function, but how can you concatenate other functions - such as Vlookup...
- Discussion threads 2006-03-22
- << Previous
- page 1 of 6
- Next >>
Content Types
Refining Tags
- Software (68 results)
- Microsoft Windows (42 results)
- Operating Systems (37 results)
- Microsoft Excel (33 results)
- Office Suites (31 results)
- Microsoft Office (31 results)
- Mobile (25 results)
- Hardware (23 results)
- Productivity (15 results)
- Apple Macintosh (14 results)
- Mary Ann Richardson (13 results)
- Marketing (12 results)
- Cell (11 results)
- Desktops (10 results)
- Finance (9 results)
- Advertising & Promotion (9 results)
- Microsoft Office Suite Excel Tips Newsletter (9 results)
- Enterprise Software (7 results)
- Management (6 results)
- Handhelds (6 results)
- Susan Harkins (5 results)
- Networking (5 results)
- Microsoft Corp. (4 results)
- Peripherals (4 results)
- Equation (4 results)
- excel (4 results)
- Palm OS (4 results)
- Personal Technology (4 results)
- Document Management (3 results)
- Workforce Management (3 results)
- Digital Music (3 results)
- AvoCalc Calculator (3 results)
- Apple iTunes (3 results)
- Managerial Accounting (3 results)
- Keyboards (3 results)
- Strategy (3 results)
- programming (3 results)
- Shareware (3 results)
- Consumer Electronics (3 results)
- Filemaker Inc. (3 results)
- Human Resources (3 results)
- Digital Media (3 results)
