Monday, January 24, 2005

Arithmetic Operations in Excel

In Excel the normal mathematical order of operation exists in formulas. That is that arithmetic operators are processed in the following order, and internal nested brackets treated first.
^ to the power of
* multiply
/ divide
+ plus
- minus

So remember when making a formula that involves multiple operators that you use brackets where necessary.
For example 24/2+4 = 16 but if you wanted the answer to be 4 then you would need to use 24/(2+4).