Quick Links ▼

Bookmark page

Printable version

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » No question

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

No question

Resolved · Low Priority · Version Standard

Reply Fri 8 Feb 2008, 16:02Delegate Adesina said...

Adesina has attended:
Excel Advanced course

No question

no question

For upcoming training course dates see: Pricing & availability

Reply Fri 8 Feb 2008, 22:26Trainer Pete said...

RE: No question

Hi Adesina, Thank you for the post, I look forward to you posting a question in the future. Please take advantage of the 12 months support you now have on this forum, best regards Pete

Excel articles

· Advanced Excel and PivotTable Reports
· Which Is Better, Excel Or Access?
· Crazy Things People Have Done With Excel
· Excel Brings You The Tools To Spice Up Your Spreadsheets
· Find Out Your Age In Days With Excel

Please browse our web site to find out more about
excel courses and other Microsoft training courses.

Excel tip:

Checking formulas with multiple operators

When dealing with formulas containing more than one operator (+, -, /, *), Excel follow standard BEDMAS order of operation rules. These rules specify the order that calculations will be performed in, regardless of how the formula reads left to right:

B = brackets
E = exponents
D = division
M = multiplication
A = addition
S = subtraction

It should be noted that multiplication and division are considered equal; as are addition and subtraction.

If you would like to check the order in which Excel is performing calculations in a formula, simply click on the cell containing the formula. Then go to Tools - Formula Auditing and select Evaluate Formula.

In the Evaluate Formula dialogue box that appears on your screen, click the Evaluate button to see how Excel calculates the formula result.

View all Excel hints and tips