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

exell

ResolvedVersion 2003

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

Edited on Fri 12 Dec 2008, 17:40

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

Excel tip:

Percentage format

Ctrl+Shift+% applies the Percentage format, with no decimal places.

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.