2. Basic Facts about Formulas

  1. John Walkenbach

Published Online: 1 NOV 2011

DOI: 10.1002/9781118257630.ch2

Excel® 2010 Formulas

Excel® 2010 Formulas

How to Cite

Walkenbach, J. (2010) Basic Facts about Formulas, in Excel® 2010 Formulas, Wiley Publishing, Inc., Hoboken, NJ, USA. doi: 10.1002/9781118257630.ch2

Publication History

  1. Published Online: 1 NOV 2011
  2. Published Print: 10 MAY 2010

ISBN Information

Print ISBN: 9780470475362

Online ISBN: 9781118257630

SEARCH

Keywords:

  • basic facts;
  • formulas;
  • edit;
  • paste;
  • Excel

Summary

This Chapter contains sections titled:

  • Entering and Editing Formulas

  • Using Operators in Formulas

  • Calculating Formulas

  • Cell and Range References

  • Making an Exact Copy of a Formula

  • Converting Formulas to Values

  • Hiding Formulas

  • Errors in Formulas

  • Dealing with Circular References

  • Goal Seeking