I am trying to do a simple formula to add, multiply and divide certain criteria. When I complete it on a calculator it comes out correct but when I try to enter the formula the total is incorrect. Please see attached file for detailed information. Thank you
so what that means is the proper order of the calculations is to resolve Brackets first, and then "Of"(as in 5% Of), Multiplication and Division and lastly Addition and Subtraction.
So put ( brackets) around all the stuff you are adding and then multiply outside the brackets.
A common technique for remembering the order of operations is the abbreviation "PEMDAS", which is turned into the phrase "Please Excuse My Dear Aunt Sally". It stands for "Parentheses, Exponents, Multiplication and Division, and Addition and Subtraction". This tells you the ranks of the operations: Parentheses outrank exponents, which outrank multiplication and division (but multiplication and division are at the same rank), and these two outrank addition and subtraction (which are together on the bottom rank).