Click the Percent Style button Home tab Number group to display the resulting decimal fractions as percentages. In this lesson we solve problems where we find the total amount given the partial amount and the percentage. Enter the formula C2B2 in cell D2 and copy it down to as many rows as you need.
If you want to calculate a percentage of a number in Excel simply multiply the percentage value by the number that you want the percentage of.
Words in problems like altogether entire in all whole mean the total. In cell B3 divide the second years sales 59863400 by the first year 48500000 and then subtract 1. To do so first well select the entire column E and then press the shortcut key ie. To find a percent of a number use this variant of the formula.