Spreadsheet calculations looking off? Check for a ‘PEDMAS’ formula error

When creating formulas in Excel, it's important to be mindful of something from high school algebra that you may have forgotten about.

If your formula has a combination of addition, subtraction, multiplication (the asterisk key) and/or division (the backslash key), Excel will prioritize calculation according to the mathematical order of…

Get This Excel Tip & Much More …

With a Resourceful Finance Pro Insider membership you'll get immediate access to the Excel Tip you're looking at right now, plus all this in your account on day one:

4 Blueprints (PDF) – detailed, step-by-step frameworks, advice and recommendations for navigating everyday management challenges and difficult situations.
14 Essential Insights (PDF) – concise, 20- to 30-page executive summaries that deliver quick tips, distilled research and curated knowledge on a specific topic.
76 Practical Tools (PDF) – desk references such as checklists, worksheets, scripts, and more to help implement new ideas. Bridging the gap between advice and execution.
100+ HR Legal Q&A's – questions by HR practitioners with answers by practicing employment law attorneys.
50+ You Be The Judge Quizzes – court judgments that present the key facts in story form and allow you to guess the outcome before seeing how the court ruled, with analysis from our expert HR team and what it means to you in practice.
50+ What Would You Do? Scenarios – challenging HR situations with the recommendations of three HR practitioners on how to resolve them.
100+ HR Case Studies – short to medium length-case studies – success stories from HR professionals – that you can adapt to your unique company situation.

Quality, reliable information you can trust – professionally curated, distilled and delivered to you all in one place.

BECOME A

NOW
Get this Excel Tip plus 400+ resources
FREE for 21 days

Get This Excel Tip & Much More …

WELCOME BACK!

Reset Password