Using Formulas and Functions in Your Worksheets

  • Guy Hart-Davis


Many of your worksheets will likely need to perform calculations with your data. To perform calculations in Excel, you enter formulas and functions in the appropriate cells in the worksheets. This chapter will explain what formulas and functions are, and what the difference between them is, and then shows you how to use each. Along the way, you will learn how to refer to cells and ranges, meet the calculation operators that Excel supports, and discover how to use them. You will also learn about common problems that occur with formulas and ways to troubleshoot them.


Calculation Operator Number Format Text String Round Function Function Panel 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.

Copyright information

© Guy Hart-Davis 2014

Authors and Affiliations

  • Guy Hart-Davis
    • 1
  1. 1.CAUnited States

Personalised recommendations