excel word powerpoint courses london - Formula

Resolved · Low Priority · Version Standard

Tue 27 Nov 2007, 17:07 Delegate Katherine said...

Katherine has attended:
Excel Intermediate course

Formula

how do I know what function does what - ie 'sum; is obvious but if I wanted to divide I would not know what to type or how to find out this?

Wed 28 Nov 2007, 09:07 Delegate Paul said...

RE: formula

Hi Katherine.

The best way to find out what a function does and, indeed, what functions there are, click the little 'Fx' button to the left of the formula bar. This will give a list of all the different formulas and they are sorted into different categories

the divide formula is like this: =A2/A3

Good Luck

Paul

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

excel word powerpoint courses london - Formula

Formula

RE: formula

Excel articles

Excel tip:

Quickly insert a function