Most valuable professional
  • Excel Book Excerpt

Excel Start a Formula with = or +

This page is an advertiser-supported excerpt of the book, Learn Excel 2007-2010 from MrExcel - 512 Excel Mysteries Solved. If you like this topic, please consider buying the entire e-book.

Start a Formula with = or +

Problem: Every Excel formula has to start with an equals sign. There is no equals sign on the numeric keypad. It’s a pain to type the equals sign.

Strategy: In order to make the transition from Lotus 1-2-3 to Excel less painful, Microsoft allows you to start a formula with the + sign. Because there is a huge plus key on the numeric keypad of most desktop computers, it is often easier to start the formula with plus than with equals, especially if you’re entering the rest of your formula using arrow keys. You simply type the plus sign and your formula.

LE10000135.jpg 

Figure 166 Start a Formula with = or +

Gotcha: After you press the Enter key, Excel will edit the formula to add an equals sign before the initial plus. This will cause people to ask why you are using =+2+2 instead of just =2+2.

LE10000136.jpg 

Figure 167 Excel accepts the formula, but adds an equals sign.

<-Previous Topic                    Next Topic->

For more resources for Microsoft Excel: