Trying to do formula to add, multiply and divide certain criteria. On a calculator it comes out correct but when I try to enter the formula the total is incorrect.

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered

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

Photo of Meme

Meme

  • 10 Points

Posted 3 years ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 65,280 Points 50k badge 2x thumb
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.
Photo of Meme

Meme

  • 10 Points
Thank you so much, yes that worked! I knew it had to be something simple I was forgetting. I appreciate your help!
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 65,280 Points 50k badge 2x thumb
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).