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

formula

ResolvedVersion 2003

Reena has attended:
Excel Intermediate course

Formula

I would like know what ech symbol means to make a formula eg: Divide,add between different sheets etc, more info on this please?

RE: Formula

Hi Reena,
Welcome to the forum, thank you for your question, in answer, to start off with you must always type the equals sign (=) in a cell to start your formula, if you simply wish to calculate the Sum of two values, then the formula =1+2 is sufficient, press Enter, or leave the cell and 3 (the answer) will appear.
If you use Cell references, =A1+B1 this will give you an answer (say in C1) of the two values in the two cells.
Consider the Acronym BODMAS
This is the order in which Excel calculates a formula;
B = Brackets (parenthesis) ()
O= Ordinals (raised to the power of) ^
D= Division /
M= Multiplication *
A= Addition +
S= Subtraction -
To go a little deeper; Double-click on the cell where you want the total to appear.
Try the steps below for an example;
Enter an opening parenthesis character: =(
Enter a cell reference, for example: =(E2.
Press the + key.
Enter another cell reference and a closing parenthesis character: ) for example: =(E2+E3).
Enter a minus sign and a third cell reference, for example: =(E2+E3)-E4.
Press the Enter key to accept the formula.
The cell will display the sum of the first two cells minus the third cell.
If you want to learn more about Formulas and Functions, click the fx (Insert Function) button on the Formula Toolbar, you can then cycle through all the options, be aware there are enough different functions and formulas to keep a Mathematican happy. I hope that has given you a start, if so, please click the Resolved link, best regards Pete.


 

Training courses

Training information:

See also:

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.

Excel tip:

LARGE and SMALL functions and their uses

Two of Excel's most common functions are the MAX and MIN functions which will display the largest (MAX) or smallest (MIN) value in a series. What if you need the 2nd or 3rd largest or smallest values instead of the largest or smallest?

The =LARGE(array,n) returns the nth largest value of a series.

The =SMALL(array,n) function returns the nth smallest value of a series.

In both functions, 'n' represents the order of the number you want to display. For example, putting in 2 as n will give you the second highest number; putting in 3 as n will give you the third highest number.

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.09 secs.