Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

excel 2003 visual basic intermediate course - formulars

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel 2003 visual basic intermediate course - Formulars

excel 2003 visual basic intermediate course - Formulars

ResolvedVersion Standard

Pauline has attended:
Excel Introduction course
Excel Intermediate course

Formulars

How to calculate the formular

Edited on Wed 16 Jan 2008, 09:46

RE: Formulars

Hi Pauline

To create a basic formula in Excel:

1. Click the cell where you want the result to appear

2. You always start a formula with the = (Equal) sign.

3. after the equal sing you enter the cell addresses to be calculated and the relevant symbols eg

=(B3 + C3) / F3


Hope this helps

Carlos

Excel tip:

Display Functions on Worksheets

Functions in Excel can be difficult to recall their format/syntax

For example, you want to use the =PMT function.

Enter =PMT, then select keystroke, CTRL+SHIFT+A.

This usful memory jog, will display the arguments of a function on a worksheet, allowing the user to proceed with the generation of the function



View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.