For example to find percent of total for following numbers. Select the cell where you want to display the percentage. Percent and the partial amount are given and are known quantities Cross multiplying and solving for x gives the value of the total amount.
The math to determine a percentage is to divide the numerator the number on top of the fraction by the denominator the number on the bottom of the fraction then multiply the answer by 100.
Click on Format as Table Select your favorite design. For example to find percent of total for following numbers. The calculations and formulas press the button are calculated automatically as you type. Although the percentage formula can be written in different forms it is essentially an algebraic equation involving three values.