Part 2. MM4XL Tools > 2. Analytical Tools > Business Formulas > mmRELATIVE

Business Formulas

mmRELATIVE

Category: Reporting > Metrics

The mmRELATIVE function divides an input value by the largest value in a range or by the average of all values in a range. The first instance can be used, for instance, to compute the relative market share of a brand.

Syntax

mmRELATIVE(Input_Number, Database, Optional Is_Average)

Input_Number The value to compute the relative value for
Database The values to compare the input value to
Is_Average Optional - TRUE computes the relative value against the Average of all values in the database, FALSE computes the relative value against the Largest value in the database

Example

See example file Business Formulas.xls, sheet mmRELATIVE.

Business analysis formulas for Excel. Marketing tool for professionals

Related functions
  • mmPREMIUM
  • mmLEARN
Lifetime license:

Price: euro

Vote this tool
We proudly serve
Your vote
vote1 vote2 vote3 vote4 vote5
Email:
Gender:
M
F
Age:
Position:
Department:
Comment: