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

Using Array Formulas

Here's a simple example that illustrates how array formulas work. In the Expenses workbook shown in Figure 4.1, the 2005 BUDGET totals are calculated using a separate formula for each month, as shown here:

Figure 4.1. This worksheet uses three separate formulas to calculate the 2005 BUDGET figures.



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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