advanced.excel - What is BODMAS

Resolved · Low Priority · Version Standard

Fri 4 May 2007, 15:08 Delegate robert said...

robert has attended:
No courses

What is BODMAS

What is bodmas

Fri 4 May 2007, 17:44 Trainer Andrew said...

RE: what is BODMAS

Hi Robert

BODMAS stands for

Brackets Other Division and Multiplication Addition and Subtraction

It's a way of remembering the order of operation that Excel follows when it evaluates values in a formula.

You can find some good examples here:

http://www.bbc.co.uk/schools/ks3bitesize/maths/number/whole_numbers_2_3.shtml

Do let us know if you have any further questions.

Kind regards,

Andrew

Excel tip:

##### displaying in Excel

When you get a series of hash symbols (####) appearing in some of your cells in a spreadsheet, this can make you think that you've make some kind of mistake.

This is a common misconception - what this actually means is that the cell is not wide enough to fully display the content of the cell.

All you need to do to see what is actually in the cell is to widen the column that the cell is in.

View all Excel hints and tips

advanced.excel - What is BODMAS

What is BODMAS

RE: what is BODMAS

Excel articles

Excel tip:

##### displaying in Excel