# XL： 在公式中的運算順序

##### 結論

`   :                 Range   space             Intersection   ,                 Union   -                 Negation   %                 Percentage   ^                 Exponentiation   * or /            Multiplication or Division   + or -            Addition or Subtraction   &                 Text Operator   = < > <= >= <>    Comparison Operators				`
##### 其他相關資訊

`   =(5*4+2)				`

`   =5*(4+2)				`

##### 参考

`   operators, evaluation order in formulas				`

`   operators, precedence				`

`   Operator				`

#### 警告：本文為自動翻譯

Microsoft Excel 2.0 Standard Edition, Microsoft Excel 2.01, Microsoft Excel 2.1 Standard Edition, Microsoft Excel 2.10c, Microsoft Excel 2.10d, Microsoft Excel 3.0 Standard Edition, Microsoft Excel 4.0 Standard Edition, Microsoft Excel 4.0a, Microsoft Excel 4.0c, Microsoft Excel 5.0 Standard Edition, Microsoft Excel 5.0c, Microsoft Excel 95 Standard Edition, Microsoft Excel 95a, Microsoft Excel 97 Standard Edition, Microsoft Excel 1.0 for Macintosh, Microsoft Excel 1.03 for Macintosh, Microsoft Excel 1.04 for Macintosh, Microsoft Excel 1.06 for Macintosh, Microsoft Excel 1.5 for Macintosh, Microsoft Excel 1.5a for Macintosh, Microsoft Excel 2.2 for Macintosh, Microsoft Excel 2.2a, Microsoft Excel 3.0 for Macintosh, Microsoft Excel 4.0 for Macintosh, Microsoft Excel 5.0 for Macintosh, Microsoft Excel 5.0a for Macintosh, Microsoft Excel 5.0 for Macintosh, Microsoft Excel 5.0a for Macintosh, Microsoft Excel 98 for Macintosh

• kbnosurvey kbarchive kbmt kbinfo KB25189 KbMtzh