Converting Using IF Formulas

The first column in price.cma contains a scenario code, 001 for actual and 002 for budget. You can use the Excel IF function to convert the code to the name of the corresponding element from the Actvsbud dimension.

Procedure

  1. Click cell A3 of the processing worksheet.
  2. Enter the following formula: 
    =IF(A1="001","Actual","Budget")