To insert a formula do the following. This formula divides the value in cell A1 by the value in cell B1. Active 3 years 11 months ago.
To do this click inside the last cell in the fourth column click on Layout in the ribbon and then click on Formula at the far right.
B2 1C2 The first calculated formula is 1C2. On the Home tab in the Number group click the percentage symbol to apply a Percentage format. On the Table Tools Layout tab click the Formula button. You can type in the Formula box select a number.