Excel

%3CLINGO-SUB%20id%3D%22lingo-sub-2009019%22%20slang%3D%22en-US%22%3EExcel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2009019%22%20slang%3D%22en-US%22%3E%3CP%3EGood%20day%20to%20all%2C%3C%2FP%3E%3CP%3EI%20am%20relatively%20new%20to%20Excel%20and%20only%20know%20the%20basics.%20My%20problem%20is%20finding%20the%20correct%20formula%20for%20minus%20inputs%20in%20calculations.%20I%20would%20like%20to%20understand%20how%2C%20after%20a%20lot%20of%20inputs%2C%20the%20end%20result%20has%20taken%20the%20minus%20numbers%20into%20account.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2009019%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2009452%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2009452%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F909276%22%20target%3D%22_blank%22%3E%40Badger_1168%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EExcel%20is%20doing%20the%20operation%20according%20to%20the%20following%20order.%3C%2FP%3E%3CP%3E%3D5%2B3*2%26nbsp%3B%20the%20result%20is%2011%2C%26nbsp%3Bexcel%20will%20start%20doing%203*2%26nbsp%3B%20then%20adding%20the%20result%20to%205%26nbsp%3B%3C%2FP%3E%3CP%3Eif%20you%20want%20first%20to%20do%20the%20adding%20operation%20you%20have%20put%20them%20inside%20(%20)%3C%2FP%3E%3CP%3E%3D%20(5%2B3)*2%26nbsp%3B%20the%20result%20is%2016%26nbsp%3B%20%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20order%20of%20operations%20for%20Excel%20is%20as%20follows%3A%3C%2FP%3E%3CUL%20class%3D%22level-one%22%3E%3CLI%3E%3CP%20class%3D%22first-para%22%3EEvaluate%20items%20in%20parentheses.%3C%2FP%3E%3C%2FLI%3E%3CLI%3E%3CP%20class%3D%22first-para%22%3EEvaluate%20ranges%20(%3A).%3C%2FP%3E%3C%2FLI%3E%3CLI%3E%3CP%20class%3D%22first-para%22%3EEvaluate%20intersections%20(spaces).%3C%2FP%3E%3C%2FLI%3E%3CLI%3E%3CP%20class%3D%22first-para%22%3EEvaluate%20unions%20(%2C).%3C%2FP%3E%3C%2FLI%3E%3CLI%3E%3CP%20class%3D%22first-para%22%3EPerform%20negation%20(-).%3C%2FP%3E%3C%2FLI%3E%3CLI%3E%3CP%20class%3D%22first-para%22%3EConvert%20percentages%20(%25).%3C%2FP%3E%3C%2FLI%3E%3CLI%3E%3CP%20class%3D%22first-para%22%3EPerform%20exponentiation%20(%5E).%3C%2FP%3EPerform%20multiplication%20(*)%20and%20division%20(%2F)%2C%20which%20are%20of%20equal%20precedence.%3C%2FLI%3E%3CLI%3E%3CP%20class%3D%22first-para%22%3EPerform%20addition%20(%2B)%20and%20subtraction%20(-)%2C%20which%20are%20of%20equal%20precedence.%3C%2FP%3E%3C%2FLI%3E%3CLI%3E%3CP%20class%3D%22first-para%22%3EEvaluate%20text%20operators%20(%26amp%3B).%3C%2FP%3E%3C%2FLI%3E%3CLI%3E%3CP%20class%3D%22first-para%22%3EPerform%20comparisons%20(%3D%2C%20%26lt%3B%26gt%3B%2C%20%26lt%3B%3D%2C%20%26gt%3B%3D).%3C%2FP%3E%3C%2FLI%3E%3C%2FUL%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Good day to all,

I am relatively new to Excel and only know the basics. My problem is finding the correct formula for minus inputs in calculations. I would like to understand how, after a lot of inputs, the end result has taken the minus numbers into account. 

3 Replies

Hi @Badger_1168 

 

Excel is doing the operation according to the following order.

=5+3*2  the result is 11, excel will start doing 3*2  then adding the result to 5 

if you want first to do the adding operation you have put them inside ( )

= (5+3)*2  the result is 16   

 

The order of operations for Excel is as follows:

  • Evaluate items in parentheses.

  • Evaluate ranges (:).

  • Evaluate intersections (spaces).

  • Evaluate unions (,).

  • Perform negation (-).

  • Convert percentages (%).

  • Perform exponentiation (^).

    Perform multiplication (*) and division (/), which are of equal precedence.
  • Perform addition (+) and subtraction (-), which are of equal precedence.

  • Evaluate text operators (&).

  • Perform comparisons (=, <>, <=, >=).

@Badger_1168 

These links might provide more use and explanation:

Subtract Numbers 

Basic Math in Excel 

Formulas and Functions

@Badger_1168 

The key point here is not to mix negation and subtraction, unfortunately Excel uses same "minus" sign for both. Negation change the sign and has highest priority, subtraction is used to subtract one value from another and has relatively low priority.

 

Thus =-3^2 returns 9 (plus nine, not minus nine). Here is negation, it has high priority and applied first, after that result is powered. Other words =-3^2 =>   =(-3)^2   => 9

Formula like =------3^2 also works and also returns plus 9 (all negations are applied first), as well as =0+-3^2

But both =0-3^2 and =0-(-3^2) return minus 9