Forum Discussion
Excel cell calculation
Hi all, first timer here. In Mac Excel I’m wanting to calculate a selling price minus a cost price times the amount of items. So cell D4 is $3, minus cell C4 which is $1, multiplied by 18 items B4....
Excel evaluates mathematical expressions according to the PEMDAS rule, which you may have heard of: (first) evaluate what is inside Parentheses; next evaluate Exponentiation; next evaluate Multiplication and Division (left-to-right); next evaluate Addition and Subtraction (also left-to-right). But Excel has a few more operators, so see this Microsoft documentation, specifically, the Operator Precedence section.