Exell

Resolved · Medium Priority · Version 2003

Fri 12 Dec 2008, 11:26 Delegate Hend said...

Hend has attended:
Excel Introduction course
Excel Intermediate course
Word Intermediate course
Word Advanced course

Exell

what is the order of calculation rule for the formula:

A1+B1*C1

Fri 12 Dec 2008, 17:38 Edited on Fri 12 Dec 2008, 17:40 Trainer Pete said...

RE: exell

Hi Hend,
Thank you for the question;
In answer; follow the acronym
BODMAS this will give you the sequence that Excel follows in processing a formula.
B=Brackets (Parenthesis)
O=Ordinals (To the power of ^)
D=Division
M=Multiplication
A=Addition
S=Subtraction

So therefore the sequence would be =B1*C1 then +A1
I hope that has helped ... Pete

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Excel tip:

Create own ribbon tab - Excel 2010

a. In Excel click on the File tab
b. Select Options from left hand side
c. Choose the Customize Ribbon section
d. Click the New Tab button (below the list of tabs on the right hand side of the dialog box)
e. Select the New Tab (Custom) and enter a name, by clicking the Rename button (below the list of tabs on the right hand side of the dialog box)
f. Select the New Group (Custom) and enter a name, by clicking the Rename button (below the list of tabs on the right hand side of the dialog box)
g. Add commands to your tab and group by locating them on the list on the right hand side (remembering that you can change the list using the drop down box at the top of the list of commands) and clicking the Add button between the two panes to add them to your tab and group
h. You can rearrange the commands in your group, the groups on any tab or the tabs, using the up and down arrow buttons beside the list of tabs.
i. Click OK to apply your changes

View all Excel hints and tips