Site Search

Exel-lent Marketing Formulas for Excel

General Utilities

Function	Computes
Growth Rate	Growth rate between two periods.
CAGR (Compound Annual Growth Rate)	Growth rate over a number of periods.
Weighted Average	Average weighted by weighting factors.
Index Number	Indexes related to a base number.
DBZ	Divides by zero. If divisor is zero, substitutes another value
New Month	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.
Qtr Format	Formats a date value in the appropriate quarter in QN_YY format.
New Qtr	Creates cell that is one month from the previous one. Can use as a series to set-up month titles for cells.
Cumulative	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.
Short Distance	Computes distances over a short span. Useful for quick computations without considering Earth's curvature.
Long Distance	Computes distances over a long span. Much more accurate when using latitudes and longitudes because the calculation considers the Earth's curvature.
Lookup 2D	Looks up a value in a two dimensional array.
Currency Conversion	Converts foreign currency to dollars (or other amounts)

You can try Exel-lent Marketing Formulas for 30 days. Click here for a fully functional trial version. When prompted, Save to your computer, then Run (or Open).

Or buy today for only ~~$39.95~~ $29.95. That's less than ~~$1.00~~ 40� per solution. Click here to start today.

InfoTech Marketing, 9888 W. Belleview Ave., Suite 472, Littleton, CO 80123 Phone: 720-732-4588 Fax: 720-528-7682
Revised: October 09, 2006