• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 11. Entering Data and Formulas > Calculating Numbers in Nonadjacent Cel...

Calculating Numbers in Nonadjacent Cells

When you build a formula, you can select cells from anywhere in your workbook.

To calculate numbers in nonadjacent cells:

1.
Click the destination cel for the formula.

2.
Start the formula as usual with an equal sign and type a function, if necessary, followed by a left parenthesis (Figure 11.37).

Figure 11.37. Click the destination for the formula and start with the equal sign and left parenthesis.


3.
Click the first cell you want to include and add an operator (Figure 11.38).

Figure 11.38. Click a cell and add an operator.


4.
Repeat step 3 until you have included as many cells as necessary (Figure 11.39).

Figure 11.39. Continue clicking cells and adding operators until formula is complete.


5.
Press Enter to enter the formula (Figure 11.40).

Figure 11.40. The cell displays the result of the formula.



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint