What is the order of operations used when evaluating formulas in Excel?

Microsoft Dynamics Microsoft Excel Microsoft Office

Question added by Mohammad Shahid , accounts trainee , KK Associates
Date Posted: 2017/11/02

Upvote (0) Views (2) Followers (1) Answers (1) Report Question

Write an Answer
Register now or log in to answer.

1 Answers

by Amatul Azeem Asra , Office Administrator , Global Studies Institute

This order of operations can be expressed by the mnemomic phrase "Please Excuse My Dear Aunt Sally", which stands for: Parentheses - Exponents - Multiplication and Division - Addition and Subtraction

Upvote (0)

Downvote Reply () Report

More Questions Like This

Can you use financial formulas in excel ?!
Top Answer: <p>How to create and use formulas and functions in Excel and other spreadsheet programs.</p> ... See More

Answers (5)
In Microsoft office 2013 if I wana use a formula in ms excel that gives me an output True if my inputs are equal only and the same?
Top Answer: =if(cell Ref1=Cell Ref2, "True", "False") Or If you have a lot of values spread in various columns then y ... See More

Answers (6)
In ms office 2013 if I wana use a formula in ms excel that gives me an output True if my inputs are not equal they are different?
Top Answer: I'm agree with all answers, Thank you Mr. Ahmad Maher for invitation See More

Answers (5)
Do you use Calculator or Excel Formulas for Calculations?
Top Answer: Depends on individual requirement. See More

Answers (5)

Products By Bayt.com

Use Our Mobile App

Start networking and exchanging professional insights

What is the order of operations used when evaluating formulas in Excel?

Popular Searches

More Questions Like This