PercentOfTotal

PercentOfTotal is a mathematical function that returns the result of a numeric value, row, column, or cell divided by another numeric value, row, column, or cell which is multiplied by 100. The function syntax is:

  PercentOfTotal (arg1, arg2)

Examples:

The following example returns the value of 5 percent.

PercentofTotal(20, 400)

The following example divides the value of each cell in column A by the Total Mkt value in cell A5, multiplies the result by 100, and displays the resulting PercentOfTotal in column B. The formula:

 PercentOfTotal ([A], [A,5]),

Using the above example, the following table shows the PercentOfTotal results in column B:

  

A

B

1

 

Sales

% Total

2

Mkt1

60

20%

3

Mkt2

120

40%

4

Mkt3

120

40%

5

Total Mkt

300

100%

Tip:

You enter the formula by clicking on the header for Column B and using the formula bar.