View Single Post
Old 09-16-2011, 03:19 PM
  #15  
MTS
Banned
 
Join Date: Nov 2010
Posts: 4,134
Default

The parens are really important.

Here's an example:

=4+2*5+3

If you just put that in a cell, then Excel thinks the answer is 17.

But what if I really meant
=(4+2)*(5+3)

or

=(4+2)*5+3

So you needed to group your numbers by function so they could be performed in the order you wanted.


I'm glad you're not crying anymore. ;-)
Please feel free to give a yell if you have any more questions.
I dream in spreadsheets. :mrgreen:
MTS is offline