mytest > help > Part 2. MM4XL Tools > 2. Analytical Tools > Business Formulas > mmSHARE

Business Formulas

mmSHARE

Category: Reporting > Metrics

The mmSHARE function returns a value computed as the share of the column or row total, depending on the user-selected direction of the database. It can be used to compute the market share and the relative market share.

Syntax

mmSHARE(Database, Optional Direction, Optional Relative_Share)

Database The range holding the data to be converted in shares
Direction Optional - Vertical = Missing or 1; Horizontal = 2
Relative_Share Optional - TRUE returns a relative share = Value divided maximum column or row value. FALSE returns a share, which is a total divided by the column or row total.

Example

See example file Business Formulas.xls, sheet mmSHARE.

Business analysis formulas for Excel. Marketing tool for professionals

Related functions
  • mmBEI
  • mmCAGR
  • mmCSII
  • mmCSIW
  • mmEI
  • mmGROWTH
  • mmHERF
  • mmLEARN
  • mmMSAR
  • mmPREMIUM
Related MM4XL software tools
  • Profile Manager
  • BCG Matrix
  • Semantic Differential
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: