3. Excel Formulas and Functions

  1. E. Joseph Billo

Published Online: 1 NOV 2011

DOI: 10.1002/9781118093955.ch3

Excel for Chemists®: A Comprehensive Guide, Third Edition

Excel for Chemists®: A Comprehensive Guide, Third Edition

How to Cite

Billo, E. J. (2011) Excel Formulas and Functions, in Excel for Chemists®: A Comprehensive Guide, Third Edition, John Wiley & Sons, Inc., Hoboken, NJ, USA. doi: 10.1002/9781118093955.ch3

Publication History

  1. Published Online: 1 NOV 2011
  2. Published Print: 16 SEP 2011

ISBN Information

Print ISBN: 9780470381236

Online ISBN: 9781118093955

SEARCH

Keywords:

  • Excel formulas;
  • Excel functions;
  • constants;
  • operators;
  • function arguments

Summary

This chapter contains sections titled:

  • The Elements of a Worksheet Formula

  • To Enter a 3-D Reference by Selecting

  • Worksheet Functions: An Overview

  • Using Insert Function

  • Math and Trigonometric Functions

  • Statistical Functions

  • Logical Functions

  • Date & Time Functions

  • Text Functions

  • Lookup and Reference Functions

  • Information Functions

  • Creating “Megaformulas”

  • The Order in Which Excel Performs Operations in Formulas

  • Excel 2003 Formula and Function Specifications

  • Excel 2007/2010 Specifications