advanced.excel - what bodmas

TrustPilot

starstarstarstarstar Excellent

  • Home
  • Courses
  • Promotions
  • Schedule
  • Formats
  • Our Clients

Forum home » Delegate support and help forum » Microsoft Excel Training and help » advanced.excel - What is BODMAS

advanced.excel - What is BODMAS

resolvedResolved · Low Priority · Version Standard

robert has attended:
No courses

What is BODMAS

What is bodmas

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


Server loaded in 0.11 secs.