Forum home » Delegate support and help forum » Microsoft Excel Training and help » Formulas

Formulas

ResolvedVersion 2003

Mon 17 Aug 2009, 16:55 Delegate Jane said...

Jane has attended:
Excel Intermediate course
Excel Advanced course

Formulas

what is the difference between using = or + at the begining of a formula?

Wed 19 Aug 2009, 09:23 Trainer Andrew said...

RE: formulas

Hi Jane

Great question! In practice there is no difference. Both work the same though there is a slight advantage for keyboard users. If you prefer to use the numberpad keyboard then starting a formla with + is quicker to type than reaching out for the equals symbol. Other than that it can look a little strange in the formula but should work the same.

I hope this helps - do let us know if you have any other questions.

Kind regards,
Andrew

Training courses

98.7 % recommend us

More live stats...

Training information:

Excel tip:

Quickly insert a function

In Excel 97 and 2000 it was known as the Paste Function dialog box, these days it's known as the Insert Function dialog box. Regardless, one has to choose Insert|Function. or the fx button to open it up. There is, however, a non-mousey way to get hold of the Insert Function dialog box: press Shift+F3 in a blank cell to open the Insert Function dialog.

Press Shift+F3 after a function name and open bracket to open the Function Arguments dialog. For example, type =VLOOKUP( into a cell and press Shift+F3 to obtain a detailed description of VLOOKUP's arguments.

View all Excel hints and tips

Formulas

Formulas

RE: formulas

Excel articles

Excel tip:

Quickly insert a function