Llang also wants to show the remaining amount as a percentage of the completed amount. Enter this information as follows:
a. In cell 15, enter a formula that divides the remaining dollar amount (cell H5) by the estimated dollar amount (cell G5).
b. Copy the formula in cell 15 to the range 16:115, pasting only the formula and number formatting to display the remaining amount as a percentage of the actual amount for the other work and the total.
To complete this task, follow these steps:
a. In cell 15, enter the following formula:
=H5/G5
This formula will divide the remaining dollar amount in cell H5 by the estimated dollar amount in cell G5, and display the result as a decimal.
b. After entering the formula in cell 15, select cell 15 and copy it (Ctrl+C or Command+C).
c. Next, select the range from cell 16 to cell 115 (cells 16:115). You can do this by clicking on cell 16, holding the Shift key, and then clicking on cell 115.
d. With the range selected, right-click on it and choose "Paste Special" from the context menu.
e. In the Paste Special dialog box, select "Formulas" under Paste, and choose "Number" under Number Formats.
f. Click the OK button to apply the paste operation.
Now, the formula from cell 15 will be copied to the range 16:115, displaying the remaining amount as a percentage of the estimated amount for each work item.