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
 10 Points
Posted 3 years ago
QuickBaseCoach App Dev./Training, Champion
 59,768 Points
If you post the code here so its copy and pastable I can correct it. Basically, if you were a geek like me and remember grade 5 math, your teacher might have taught BOMDAS.
Brackets
Of
Multiplication
Division
Addition
Subtraction
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.
Brackets
Of
Multiplication
Division
Addition
Subtraction
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.
 10 Points
Thank you so much, yes that worked! I knew it had to be something simple I was forgetting. I appreciate your help!
QuickBaseCoach App Dev./Training, Champion
 59,768 Points
Just for completeness I will also post this alternative memory aid. :)
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).
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).
Related Categories

Formulas & functions
 2836 Conversations
 66 Followers