Everyday Computing Advanced Computing The Internet At Home Health, Mind & Body Making & Managing Money Sports & Leisure Travel Beyond The Classroom
Handheld Computing
Hardware
Money Management Software
Multimedia
Office Productivity Software
Operating Systems
Moms, Dads, and Grads -- Win $500!
Excel 2002 Formulas
Acceptable Ways to Begin an Excel Formula
Adapted From: Excel 2002 Formulas

When you type an equal sign into an empty cell, Excel assumes that you are entering a formula (a formula always begins with an equal sign). Excel's accommodating nature also permits you to begin your formula with a minus sign or a plus sign. However, Excel always inserts the leading equal sign after you enter the formula.

As a concession to former 1-2-3 users, Excel also enables you to use an @ symbol to begin a formula that stars with a function. For example, Excel accepts either of the following formulas:

=SUM(A1:A200)

@SUM(A1:A200)

However, after you enter the second formula, Excel replaces the @ symbol with an equal sign.


To find out how to have Dummies eTips delivered to your e-mail inbox every week, visit the Dummies eTip Sign-Up Page.
Related Articles
Tearing Off Toolbars in Office XP
Using Columns and Bars to Compare Items in Excel Charts
Getting to Know Basic Data Entry in Excel
Using the Excel Insert Function Button
Finding the Correct Excel Function
Related Titles
Microsoft Office 97 For Windows For Dummies
Microsoft Office 97 For Windows For Dummies : Quick Reference
Microsoft Office 2000 9 in 1 For Dummies Desk Reference
Microsoft Office 2000 For Windows For Dummies
Microsoft Office 2000 for Windows For Dummies: Quick Reference