On CBS.com: No Line On The Horizon by U2
117 Resources for

formula

  • Subscribe to this listing via:
  • RSS
  • Email
Did you mean formula (117 results)

TechRepublic Resources

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
Tags: Formula, Microsoft Excel 2007, Microsoft Excel, Microsoft Office, Office Suites, Software, 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
Tags: Mouse, Formula, Keyboards, Microsoft Excel, Mice, Microsoft Office, Hardware, Peripherals, Office Suites, Software, 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
Tags: Formula, Microsoft Excel, Microsoft Office, Office Suites, Software, 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
Tags: Microsoft Access, Formula, Microsoft Office, Databases, Office Suites, Software, Enterprise Software, Data Management, 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...
Tags: Formula, Cell, Microsoft Excel, Microsoft Office, Office Suites, Software, Mary Ann Richardson
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...
Tags: Formula, Microsoft Excel, Microsoft Office, Office Suites, Software, Susan Harkins
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...
Tags: Coca-Cola Co., Formula, Food & Beverage, Manufacturing, Jay Garmon
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...
Tags: Formula, Cell, Microsoft Excel, Microsoft Office, Office Suites, Software, Mary Ann Richardson
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...
Tags: Revelation, Formula, Specification, Microsoft Corp., OpenDocument Format (ODF), Tools & Techniques, Emerging Technologies, Management, John Bartley K7AAY
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...
Tags: Microsoft Excel, Microsoft Office, Mary Ann Richardson, Sales strategy, Sales force management, Excel spreadsheet, Click Add, sales, Total Sales, Microsoft Office Suite Excel Tips Newsletter, Formula, Office Suites, Software
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...
Tags: Microsoft Excel, Microsoft Office, Mary Ann Richardson, PRODUCTIVITY, Excel spreadsheet, natural language, spreadsheet, Microsoft Office Suite Excel Tips Newsletter, Formula, Office Suites, Software
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...
Tags: Formula, Equation, Person, Leadership, Strategy, Management, Sonja Thompson
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...
Tags: tang0312, cell, excel 2003, programming, software, microsoft, office, formula, Microsoft Excel
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...
Tags: Microsoft Excel, Microsoft Office, Mary Ann Richardson, Click OK, cell, Microsoft Office Suite Excel Tips Newsletter, Formula, MIN, Office Suites, Software
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...
Tags: Microsoft Excel, Microsoft Office, Mary Ann Richardson, Microsoft Office Suite Excel Tips Newsletter, Formula, Office Suites, Software
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...
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
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...
Tags: excel, formatting name, formula, Inge.Desmarais@..., Joe, Microsoft Excel, programming, software
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...
Tags: Microsoft SQL Server, Databases, Arthur Fuller, server, present value, future value, financial, SQL Server Newsletter, TechRepublic Inc., Formula, Enterprise Software, Financial Accounting, Software, Data Management, Finance
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...
Tags: excel, formula, gokhan76@..., Microsoft Excel, programming, update
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...
Tags: Microsoft Excel, cell
Discussion threads 2006-03-22


IT Help Desk Survival Guide, Third Edition
TechRepublic's IT Help Desk Survival Guide, Third Edition provides tools and recommendations to help you better manage help desk services, improve end-user support, troubleshoot frustrating hardware issues, identify quick fixes to vexing Windows problems, and help users make the most of Microsoft Office 2003.
Buy Now
500 Things Every Technology Professional Needs to Know
Did you know Microsoft's RegClean does not work with XP but you can use shareware to clean your registry? Did you know most wireless access points don't have encryption enabled by default? Did you know there are 500 tidbits of information contained in TechRepublic's 500 Things Every Technology Professional Needs to Know that will help you become a successful IT professional.
Buy Now

Introducing SmartPlanet