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

Chapter 12. Basic Excel > Formula Fundamentals

12.2. Formula Fundamentals

Without formulas, Excel would be just glorified graph paper. With them, Excel becomes a number-crunching powerhouse worthy of having its own agent. Excel formulas do everything from basic arithmetic to complex financial analysis. You can even use formulas to switch the capitalization of text, remove all nonprintable characters from a text string, and probably vacuum the living room.

12.2.1. Basic Calculations

A formula in a cell can perform calculations on other cells' contents. For example, if cell A1 contains the number of hours in a day, and cell A2 contains the number of days in a year, then you could type =A1*A2 into cell B3 to find out how many hours there are in a year. (In spreadsheet lingo, you'd say that this formula returns the number 8670.)


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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