||Growth rate between two periods.
|CAGR (Compound Annual Growth Rate)
||Growth rate over a number of periods.
||Average weighted by weighting factors.
||Indexes related to a base number.
||Divides by zero. If divisor is zero, substitutes another value
||Creates cell that is one month from the previous one. Can use as a series
to set-up month titles for cells.
|Day of Week
||Returns the 3 character day of week from a date.
||Formats a date value in the appropriate quarter in QN_YY format.
||Creates cell that is one month from the previous one. Can use as a series to
set-up month titles for cells.
||Adds a new number to a cumulative total. You don't need a different formula
for the first cumulative value if the previous cell contains text.
||Computes distances over a short span. Useful for quick computations
without considering Earth's curvature.
||Computes distances over a long span. Much more accurate when using
latitudes and longitudes because the calculation considers the Earth's
||Looks up a value in a two dimensional array.
||Converts foreign currency to dollars (or other amounts)