Adjusting Values in Data Cells

Data source types: all

You can adjust the value of one or more data cells by a specified number or percentage if the cells contain numerical data. If you adjust the value of a cell that contains an Excel formula, the adjusted value overwrites the formula.

You can adjust the values of numerical data by a specified number or percentage in

  To adjust data values:

  1. Click the data cell that contains the value to adjust.

  2. From the data source ribbon, select Adjust.

  3. From Adjust Data, select an option then enter the number or percentage by which you want to adjust the value of the cell.

  4. Click Adjust Data.