Unformatted text preview: You can also combine methods of defining cells. For example, if you wanted to find the sum of the contents of cells B3 through B28, B32 and B40 through B100 the Excel command you would use is: =sum(B3:B28,B32,B40:B100) Some other useful hints: • If in doubt, use parentheses to make sure things get calculated in the right order. For example, =3+5/2 results in 5.5. But, =(3+5)/2 results in 4. In the first case, it would be better to use =3+(5/2) in Excel. • Pushing the Ctrl + ~ keys will display the formulas for the entire spreadsheet. Pressing these two keys again reverts back to the calculated numbers....
View
Full Document
 Summer '08
 J.T.
 Physics, Addition, Excel command

Click to edit the document details