Formulas and Functions
Table Of Contents
- Formulas and Functions
- Contents
- Preface: Welcome to iWork Formulas & Functions
- Chapter 1: Using Formulas in Tables
- The Elements of Formulas
- Performing Instant Calculations in Numbers
- Using Predefined Quick Formulas
- Creating Your Own Formulas
- Removing Formulas
- Referring to Cells in Formulas
- Using Operators in Formulas
- The String Operator and the Wildcards
- Copying or Moving Formulas and Their Computed Values
- Viewing All Formulas in a Spreadsheet
- Finding and Replacing Formula Elements
- Chapter 2: Overview of the iWork Functions
- Chapter 3: Date and Time Functions
- Chapter 4: Duration Functions
- Chapter 5: Engineering Functions
- Chapter 6: Financial Functions
- Chapter 7: Logical and Information Functions
- Chapter 8: Numeric Functions
- Chapter 9: Reference Functions
- Chapter 10: Statistical Functions
- Listing of Statistical Functions
- AVEDEV
- AVERAGE
- AVERAGEA
- AVERAGEIF
- AVERAGEIFS
- BETADIST
- BETAINV
- BINOMDIST
- CHIDIST
- CHIINV
- CHITEST
- CONFIDENCE
- CORREL
- COUNT
- COUNTA
- COUNTBLANK
- COUNTIF
- COUNTIFS
- COVAR
- CRITBINOM
- DEVSQ
- EXPONDIST
- FDIST
- FINV
- FORECAST
- FREQUENCY
- GAMMADIST
- GAMMAINV
- GAMMALN
- GEOMEAN
- HARMEAN
- INTERCEPT
- LARGE
- LINEST
- Additional Statistics
- LOGINV
- LOGNORMDIST
- MAX
- MAXA
- MEDIAN
- MIN
- MINA
- MODE
- NEGBINOMDIST
- NORMDIST
- NORMINV
- NORMSDIST
- NORMSINV
- PERCENTILE
- PERCENTRANK
- PERMUT
- POISSON
- PROB
- QUARTILE
- RANK
- SLOPE
- SMALL
- STANDARDIZE
- STDEV
- STDEVA
- STDEVP
- STDEVPA
- TDIST
- TINV
- TTEST
- VAR
- VARA
- VARP
- VARPA
- ZTEST
- Chapter 11: Text Functions
- Chapter 12: Trigonometric Functions
- Chapter 13: Additional Examples and Topics
- Index
Chapter 5 Engineering Functions 81
Speed
Measure Constant
Miles per hour “mi/h”
Miles per minute “mi/mn”
Meters per hour “m/h” (can be used with metric prexes)
Meters per minute “m/mn” (can be used with metric prexes)
Meters per second “m/s” (can be used with metric prexes)
Feet per minute “ft/mn”
Feet per second “ft/s”
Knot “kt”
Pressure
Measure Constant
Pascal “Pa” (can be used with metric prexes)
Atmosphere “atm” (can be used with metric prexes)
Millimeters of mercury “mmHg” (can be used with metric prexes)
Force
Measure Constant
Newton “N” (can be used with metric prexes)
Dyne “dyn” (can be used with metric prexes)
Pound force “lbf”
Energy
Measure Constant
Joule “J” (can be used with metric prexes)
Erg “e” (can be used with metric prexes)
Thermodynamic calorie “c” (can be used with metric prexes)
IT calorie “cal” (can be used with metric prexes)
Electron volt “eV” (can be used with metric prexes)
Horsepower-hour “HPh”










