Format the calculation as a percentage by using the icon on the Home tab. The total amount is the unknown quantity x that we need to find. Click on Format as Table Select your favorite design.
Here in Category select Percentage and in Decimal places select up to.
Calculate Dynamic Percentage of Total using Tables Select your table. If you are given a fraction convert it to a percentage by dividing the top number by the bottom number. Divide the number that you wish to determine the percentage forUsing the. The first is to divide the denominator of the fraction into the numerator to get a decimal fraction which is one with a base of 10.