Adjusting Values in Data Cells

You can adjust the value of one or more data cells by a specified number or percentage if the cells contain numerical data.

To adjust values, you can select a single cell or a range of multiple cells, including continuous or discontinuous cell ranges. However, while selecting a range, if you select a read-only cell, a cell with supporting details, a cell with string or non-numeric values, or a cell outside the grid, then relevant error messages inform you that the adjust operation cannot be performed and prompt you to modify your selection.

Note:

If you adjust the value of a cell that contains Excel formula, the adjusted value overwrites the formula.

To adjust data values:

1. Click the data cell that contains the value to adjust.
2. From the provider ribbon or provider ad hoc ribbon, select Adjust, and then select Adjust.
3. In Adjust Data, select an option and then enter the number or percentage by which you want to adjust the value of the cell.

   Available options are:

   • Add fixed value to selected cell(s)

   • Subtract fixed value from selected cell(s)

   • Multiply selected cell(s) by a fixed value

   • Divide selected cell(s) by a fixed value

   • Increase selected cell(s) by a fixed percentage

   • Decrease selected cell(s) by a fixed percentage

4. Click Adjust Data.