Step 2 Press Tab then in B18 enter this Excel percentage formula. B3105 These formulas simply multiply the value by five percent more than the whole of itself 100 percent. The formula below does the trick.
On the Home tab in the Number group apply a Percentage format.
On the Home tab in the Number group apply a Percentage format. 1 20 50. This time we fix the reference to cell B2. The result is 319.