How-To Geek on MSN

How to use the SCAN function in Microsoft Excel to calculate running totals

The SCAN function lives in a single cell and spills the results down the column, ensuring my totals are always structurally ...
How-To Geek on MSN

Don't trust Excel's COUNTA function to count non-blank cells—here's a better method

Counting non-empty cellsThe COUNTBLANK-COUNTA conflict (and how to fix it)Summary: Choosing the right counting functionIn ...
TechRepublic

Create a Formula for Entering a Series of Incremental Times in Excel

Create a Formula for Entering a Series of Incremental Times in Excel Your email has been sent To generate a series of incremental time values, you must first know how to use Excel's TIME() function.
Linux Journal

OpenOffice.org Calc functions, part 2: Working with formulas

A formula is a spreadsheet function entered in a cell, complete with its arguments. They're one of the two or three major applications that first spearheaded the acceptance of the personal computer in ...
Scientific American

Simple Formula Makes Prime Numbers Easy, but a Million-Dollar Mystery Remains

Would you like to be a millionaire? There are several ways to fulfill this dream. For two decades the U.S. edition of Who Wants to Be a Millionaire? promised a million dollars if you could answer 15 ...
BBC

Changing the subject of a formula

Rearranging the formula for the circumference of a circle makes the radius the subject. Start with the new subject and write out the function machine for the formula, showing each operation step by ...
Scientific American

String Theorists Accidentally Find a New Formula for Pi

The number pi (π) appears in the most unlikely places. It can be found in circles, of course—as well as in pendulums, springs and river bends. This everyday number is linked to transcendental ...